Advanced SUMPRODUCT Function: Conditional Sum

Advanced SUMPRODUCT Function: Conditional Sum

Another great way that you can use the SUMPRODUCT function is to create a conditional sum criteria.

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

John Michaloudis

Founder & Chief Inspirational Officer

at

MyExcelOnline.com

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 Academy Online Course.

See also  Excel Tips: Add 8 Weeks from Today's Date in Seconds!