Advanced SUMPRODUCT Function: Count

You can use the SUMPRODUCT function to create advanced analysis of your data set.  For example, you can calculate the number of time a sales rep has made sales in a particular region.  Watch below to see how easy it is to create a count with this advanced SUMPRODUCT function.

NB: The same result can be achieved with the Countifs formula

download workbookAdvanced-Sumproduct_Count.xlsx

If you like this Excel tip, please share it

email

Pinterest

Facebook

Twitter

Linkedin

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 INDIRECT Function Using Sheet References