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