• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iOS
  • Mac
  • Android
  • Office
Home » Office » How to Use SUMIF Function in Excel

How to Use SUMIF Function in Excel

By: Waseem Patwegar

This tutorial explains the use of SUMIF Function in Excel to count the total number of items meeting a particular Criteria.

Use SUMIF Function in Excel

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.

Computer Sales Data for SUMIF Function

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]).

SUMIF Function Syntax Provided by Excel

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.

Select SUMIF Function Range

3. Next, specify the Criteria by clicking on Cell A3 – As this Cell contains the name of item (MacBook) that you want to Sum.

Specify SUMIF Function Criteria

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.

Select SUMIF Function Sum_Range

5. Finally, close the bracket and press the Enter Key.

SUMIF Function Result

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.

Related
  • How to Use SUMIFS Function in Excel
  • How to Use COUNTIF Function in Excel
  • How to Create Pivot Table 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



Recent Posts

  • Fix: iPhone Camera Black Screen Problem
  • How to Clear Your Activity History In Windows 11
  • How to Find WiFi Password in Windows 11
  • How to Enable Touch Keyboard in Windows 11/10
  • How to Send Group Email In Gmail App On iPhone




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