Pinterest Pixel

Advanced SUMPRODUCT Function: Conditional Sum

John Michaloudis
Advanced SUMPRODUCT Function: Conditional Sum.
Another great way that you can use the SUMPRODUCT function is to create a conditional sum criteria.
Advanced SUMPRODUCT Function: Conditional Sum | MyExcelOnline Advanced SUMPRODUCT Function: Conditional Sum | MyExcelOnline

For example, you may want to find out how much sales were made above the $3,000 transactional level.  See how easy it is with this quick SUMPRODUCT example.

download workbookAdvanced-Sumproduct_Conditional-Sum.xlsx

 

 

If you like this Excel tip, please share it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  How to Use VLOOKUP between Sheets

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...