How to use the SUMIFS function in Excel In this tutorial, we want to add the total number of sales of mangoes we made from, say, Kevin Sahadeo. Click the cell where you want the result to be.

Computer Tutoring is happy to provide this free resource for those looking to summarise data accross multilple sheets in Excel. SUMIF Excel across multiple sheets is a handy formula to know if you ...

Only the second instalment of fun with functions and already we're about to go beyond functions themselves and into the realm of the array formula.

SUMIF () is a very useful function for working with accounting data. As its name implies, it sums a range of cells if their contents, or the contents of an equivalent range of codes in another column, ...