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 ...

In this tutorial, you will notice that we have ice cream at the table, but when we try to type ice cream below, the Autocomplete is not working. Once you type ice, it should show cream at the end.