• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to use SUMIFS function to sum multiple criteria in Excel

0 Comments

How to use SUMIFS function to sum multiple criteria in Excel: Excel provides users with many functions to calculate sums. In this article, we will introduce how to use the SUMIFS function to sum multiple criteria in Excel.

1. SUMIFS function structure

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

  • Sum_range: required argument, the range to be summed.
  • Criteria_range1: required argument, the range that contains the criteria for the first condition.
  • Criteria: required argument, the first condition.
  • Criteria_range2…: optional argument, the range that contains the criteria for the second condition and onwards.
  • Criteria…: optional argument, the second condition and onwards.

Note: If Criteria is in text form or contains mathematical symbols, it must be enclosed in double quotes (” “).

2. How to use the SUMIFS function

Suppose we have a revenue table as shown below. We want to calculate the total revenue of products that are Ice Powder and have a quantity greater than 30,000.

How to use SUMIFS function to sum multiple criteria in Excel

How to use SUMIFS function to sum multiple criteria in Excel

Using the above function structure, the formula for calculating the total revenue of Ice Powder products with a quantity greater than 30,000 is:

=SUMIFS(F2:F11,D2:D11,D3,E2:E11,”>30000″)

We can see that two products meet the condition, 0x4 Stone and Stone dust with revenues of 9,154,583,427 and 5,036,227,924 respectively. Adding the revenue of these two products, we get the result of the function, which is 14,190,811,351.

How to use SUMIFS function to sum multiple criteria in Excel

How to use SUMIFS function to sum multiple criteria in Excel

Thus, this article has guided you on how to use the SUMIFS function to sum multiple criteria in Excel. We hope that this article will be useful to you in your work. Good luck!

Rate this post
26
264 Views
How to use the VALUE function to convert text to number in ExcelPrevHow to use the VALUE function to convert text to number in ExcelApril 25, 2023
How to use INDIRECT function to create a reference range in ExcelApril 25, 2023How to use INDIRECT function to create a reference range in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • Windows Server 2019 Datacenter Key Global Windows Server 2019 Datacenter Key Global
    Rated 4.75 out of 5
    $7.00
  • Microsoft Visio 2019 Professional Key Global Microsoft Visio 2019 Professional Key Global - 5 PC
    Rated 4.93 out of 5
    $19.00
  • Microsoft Project Standard 2019 - 1 PC Microsoft Project Standard 2019 - 1 PC $12.00
  • Windows 10 Pro Key Global Windows 10 Pro Key Global
    Rated 4.74 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Windows 10 Pro Key Global 20 PC Windows 10 Pro Key Global 20 PC $50.00
  • Kaspersky Premium - 1 Device 1 Year - GLOBAL Kaspersky Premium - 1 Device 1 Year - GLOBAL $37.00
  • Microsoft Office Professional Plus 2013 retail CD Key Global Microsoft Office Professional Plus 2013 retail CD Key Global
    Rated 4.97 out of 5
    $11.00
  • Microsoft Visual Studio 2019 Professional Key Microsoft Visual Studio 2019 Professional Key
    Rated 4.84 out of 5
    $15.00
  • Microsoft Visio Professional 2013 Key 1PC Microsoft Visio Professional 2013 Key 1PC $9.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.