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

Advanced SUMPRODUCT Function: Count | MyExcelOnline
DOWNLOAD WORKBOOK

 

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Advanced SUMPRODUCT Function: Count | MyExcelOnline