SUMIF is a function which helps summarise data into a meaningful report. A SUMIF statement is similar to but more versatile than a pivot table. In our example, we will use the SUMIF function to demonstrate how product sales figures by country can be summarised to show total sales per product.
In this tutorial, I will show you how to use the SUMIF function.
- Create or have ready a table which you want to summarise, this can include products, country, and sales. In addition, have another table ready with the product names that you want to summarise.
- The SUMIF formula is =SUMIF(range, criteria, =SUMIF([sum_Range])
- Range – This is asking us what item we are looking for, in our example the range is the products we have sold. To do this we can go ahead and select the whole of column B by clicking on column B. We can then type a comma to close the current function.
- Criteria – This is asking us what item we want to look for from the range “Products” we have just defined. In this example, the first item we want to look for is Fridge so we will click on Fridge from the sales summary. We can then type a comma to close the current function and move on to the next.
- Sum_Range – this is asking us where the data is that we need to summarise. In this example the data that we want to summarise is the sales figures, therefore, we can select the whole of column D.
- Once this is done we can close brackets and click enter. This should then show us the total sales figure for Fridge.
- We can then drag this formula down to get the total figures for each of the products.