fbpx

Working with Excel Sumif Formula

When I ask professionals in my workshops – “Which is the ONE formula you’ll pick if you were asked to choose JUST ONE?” Most of the answers hover around INDEX, VLOOKUP and IF. But they tend to forget Excel Sumif.




You know what MY answer is – Excel SUMIFS()! And I will tell you why.

Excel Power Users Ebook

Be Smart at Excel | New Skills for New JOB

This eBook will help you to get Excel Skills & Boost your career

Excel Sumif Formula

SUMIFS() is a VERY powerful function in Excel. It can accommodate 127 criteria fields!
Let’s see an example – All “M” or males with age of at least 21 are chosen to yield an answer of $28,000. Here 2 criteria fields have been applied.

SUMIFS Excel Formula

 

ARE YOU STRUGGLING WITH EXCEL FORMULAS?
Become a "Hero at Office"• 200+ Video Lessons • Real-life Case studies • Lifetime Access

 

Applications:

  1. Building Dashboards
  2. Complex calculation involving From-To date ranges
  3. Functions using similar logic: COUNTIFS(), AVERAGEIFS()
  4. Differential cumulative/running total
  5. Condition based analysis

Our latest course, Become an Excel Ninja and a Trainer Consultant will include the following:

    • SUMIFS() – Conditional Summation (1 criteria)
    • SUMIFS() – Conditional Summation (2 criteria)
    • SUMIFS() – Conditional Summation (3 criteria) w. date range
    • SUMIFS() – Condition based Selective Cumulative Running Total
    • COUNTIFS() – Single/Multiple Criteria: Duplicate Count, Instance No.
    • AVERAGEIFS()




Also, read how to use SUMIF Function in Excel

Related Items: