Excel

# Understanding The SUMIF Function | Excel | Tutorial

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.

Video Guide

Instructions

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

## 12 thoughts on “Understanding The SUMIF Function | Excel | Tutorial”

1. Hey, Your blog looks brilliant; I am impressed. Banah Isaac

Liked by 2 people

1. I so wish that I had been able to have your site as a resource when I was running my secretarial service in the early 2000s. There are so many tips that would have been so helpful. You’re providing an excellent Excel resource for many people and demystifying a lot of the functions.

Liked by 2 people

2. Intelligirl says:

Very helpful, especially as charts generally hurt my head!

Liked by 2 people

3. We love Excel! And, now with your tips, we love it even more! Thank you so much for sharing your expertise!

Liked by 2 people

4. webb24h says:

Very great article. Excel is a fantastic software. We use it all the time here at webb24h 🙂

Liked by 1 person

This site uses Akismet to reduce spam. Learn how your comment data is processed.