• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iOS
  • Mac
  • Android
  • Office

How to Use Excel SUMIFS Function

By: Waseem Patwegar

In case you are familiar with SUMIF Function in Microsoft Excel, you might also be interested in Excel SUMIFS Function, which can be used to sum up a list of values meeting two or more conditions.

Use Excel SUMIFS Function

EXCEL SUMIFS Function

As you must be already aware, the SUMIF Function in Excel can be used to find the Sum, Count or the Total of items meeting a particular criteria or condition.

Similarly, the SUMIFS Function in Excel can be employed to find the Sum or Total of items meeting not One but multiple criteria or conditions.

For example, if there is sales data for different types of Gadgets sold at two different store locations, the SUMIFS Function can be used to count only iPads sold at the first store location.

In above case, the SUMIFS Function counts only if the the Gadget type is iPad (First Criteria) and it is sold at the First Store (Second Criteria).

1. Syntax of Excel SUMIFS Function

The Syntax of SUMIFS Function is as provided below.

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2],…)

Sum_range: The Range of Cells that you want to Sum.

Criteria_range1: The range where the item meeting the first Criteria is located.

Criteria1: The first condition or criteria, SUMIFS will be executed when these criteria is true.

Criteria_range2: The range where the second item meeting the second Criteria is located.

Criteria2: The second condition or criteria, SUMIFS will be executed when these criteria is true.

As you can see from above, the Syntax of SUMIFS function allows you to specify multiple criteria and multiple ranges in which each of these criteria is located.

2. How to Use SUMIFS Function in Excel

Take a look at the following table providing Sales Data for Windows Computers, ChromeBooks and MacBooks sold at two different store locations (Store#1 and Store#2).

Computer Sales Data at Two Store Locations

The task is to find the total number of MacBooks sold at Store#1 using the SUMIFS Function in Excel.

1. Place the cursor in Cell B14 > start typing =SUMIFS and Microsoft Excel will automatically provide you with the Syntax to follow (=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2,…).

Syntax of Excel SUMIFS Function

Note: Cell B14 is where you want to print the result.

2. Going by the Syntax, select Cells B1:B12 as the sum_range. This is where the items that you want to sum are located (number of items sold).

Select Sum Range in Excel SUMIFS Function

3. Next, select Cells A1:A12 as the criteria_range1 – this is where the first criteria (MacBook) is located.

Select Criteria Range1 in Excel SUMIFS Function

4. Select the First Criteria by clicking on Cell A5 containing the term ‘MacBook’.

Select First Criteria in Excel SUMIFS Function

5. Select Cells E1:E12 as criteria_range2 – this is where the second criteria (Store#1) is located.

Select Criteria Range2 In Excel SUMIFS Function

6. Now, select the Second Criteria by clicking on Cell E3 containing the term ‘Store#1’.

Select Second Criteria In Excel SUMIFS Function

7. Finally, close the bracket and hit the enter key.

Result Using Excel SUMIFS Function

The SUMIFS formula will instantly display the number of MacBooks sold by Store#1 in cell B14.

Related
  • How to Use COUNTIF Function in Excel
  • How to Create Pivot Table in Excel
  • How to Replace Zeros With Blank, Dash or Text in Excel

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar



Gadget Guide

  • Should You Buy MacBook or Windows Laptop
  • How Much RAM Is Required in a Computer?
  • 12 Reasons to Switch to Chromebook
  • Check RAM Size & Type In Windows 10/11
  • Which Chromecast Model to Buy




About | Privacy Policy | Disclosure | Terms | Contact
© 2023 Techbout.com · All Rights Reserved