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 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