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.

11 thoughts on “Understanding The SUMIF Function | Excel | Tutorial”

  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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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