Pinterest Pixel

Advanced SUMPRODUCT Function: Count

John Michaloudis
Free Practice Workbook
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.
Advanced SUMPRODUCT Function: Count | MyExcelOnline Advanced SUMPRODUCT Function: Count | MyExcelOnline

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
LinkedInCopyPrintReddit
Advanced SUMPRODUCT Function: Count | MyExcelOnline
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  DATEDIF function: Introduction

Steps To Follow

Excel Formulas & Functions TutorialsExcel Math FormulasSUMPRODUCT Formula in Excel

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...
BufferCopyFlipboardHacker NewsLineLinkedInMastodonMessengerMixPinterestPocketPrintRedditSMSTelegramThreadsTumblrVKWhatsAppXingYummly