# 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.

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.

A CHEATSHEET that Solve your EXCEL Problems
• eBook • Get Excel VBA Automation Course and Outlook Course as FREE • 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()
The Ultimate EXCEL GUIDE LIBRARY
• Get Excel VBA Automation Course and Outlook Course as FREE • Lifetime Access • eBook

Also, read how to use SUMIF Function in Excel

Related Items: