Download Excel Workbook
Table of Contents
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
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.
