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.

Before we experiment with the filtering, use any method you like to add a SUM() function to A9. You need to skip a row so Excel won’t interpret the function cell as data and filter it later. Filters ...