Working with Excel Sumif Formula

Yodalearning>Tutorials>Working with Excel Sumif Formula

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.

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

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()

Advanced Excel Course

Your courses were useful for me. Thank you again for your quick support and also for your availability.

- Madalina Elena Gheorghe

Free Excel Course
with 210+ Tricks
(UPDATED 2017)