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

Advanced Sumproduct_Count

Helpful Resource:

excel-formula-crash-course-from-chandoo.org

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

DATEDIF function: Introduction The DATEDIF function is a mystery function within Excel.  When you write it out in a workbook it doesn't give you any hints like other functions would and if you look it up in the function list you would not find it! Creepy... The DATEDIF function stands for "date difference" ...
Getting the length of text with Excel’s LEN ... What does it do? Gives you the number of characters of the text Formula breakdown: =LEN(text) What it means: =LEN(text that you want to get the number of characters) There are times when you need to get the number of characters within a cell in Excel.  Thank...
VLOOKUP Example: Vlookup with a Drop Down List What does it do? Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) What it means: =VLOOKUP(thi...
Cleaning Data with Excel’s TRIM Formula What does it do? Removes unneeded spaces in your text, except single spaces in between words Formula breakdown: =TRIM(text) What it means: =TRIM(text that you want extra spaces to be removed) In the quest for cleaner data, one of the common scenarios is remo...