This tutorial explains the use of SUMIF Function in Excel to count the total number of items meeting a particular Criteria.
SUMIF Function in Excel
As mentioned above, the SUMIF function in Excel is useful in summing or counting the total number of items that meet a certain conditions.
For example, the SUMIF Function can be used to quickly find the total number of Apples sold from a long combined list of Apples, Oranges and Mangoes sold at a store.
Instead of manually going through a long list of items to identify and count similar items, you can use the SUMIF Function to do this job for you in a very short time.
So, let us go ahead and take a look at the Syntax of SUMIF Function and the actual steps to use SUMIF Function in Excel.
1. The Syntax of SUMIF Function
The Syntax of SUMIF formula is as follows
=SUMIF(range, criteria, [sum_range])
Range: The range of cells on which you want to employ the criteria.
Criteria: The criteria determining which cells to Add.
Sum_range: The range of cells within which the numbers meeting the Criteria are located.
2. Steps to Use SUMIF Function in Excel
To understand the use of SUMIF Function in Excel, consider the following sales data providing the number of Windows Laptops, MacBooks and ChromeBooks sold at Store#1.
Now, the task is to find only the total number of ‘MacBooks’ sold using the Excel SUMIF Function.
1. Place the cursor in Cell B14 and start typing =SUMIF and Microsoft Excel will automatically provide you with the Syntax to follow (=SUMIF(range, criteria, [sum_range]).
2. Going by the Syntax provided, first select Cells A1:A12 as the Range – This is where the item (MacBook) that you want to count is located.
3. Next, specify the Criteria by clicking on Cell A3 – As this Cell contains the name of item (MacBook) that you want to Sum.
Note: You can also click on any cell containing the term MacBook (A5, A8, A11)
4. Select Cells B1:B12 as the sum_range – This is where the count for number of items (MacBook) sold is located.
5. Finally, close the bracket and press the Enter Key.
The SUMIF formula will instantly display the total number of MacBooks sold at the two store locations.
Similarly, you can use the SUMIF Function to count the total number of Windows Laptops and ChromeBooks sold at the two store locations.