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.

The SUMIF function in Excel is used to add all the cell values and return the results on the basis of one criterion. On the other hand, the SUMIFS formula enables you to sum up all cell values on ...

Excel’s SUMIF() and COUNTIF() are two of my favorite summarizing functions and we’ve talked about both frequently in this blog. What we haven’t discussed is how to return a conditional average.