Excel-lence.net - by Affordable Solutions
can be done with COUNTIF
Counting with Excel COUNTIF
With the COUNTIF function, you can count the number of different products based on a single criteria like date OR city OR salesperson... SUMPRODUCT is like Excel COUNTIF on steroids, with SUMPRODUCT you can count the number of different products based on date AND city AND salesperson AND any number of other criteria...
When you use Excel SUMPRODUCT function formulas in a report to look at a set of data, you can just change the data and the report is AUTOMATICALLY refreshed.
The Excel COUNTIF Function
The general format for the COUNTIF formula is as
The Excel COUNTIF function is limited to one criteria (one column). If you want to count the amounts based on month, State and name, discover the very simple SUMPRODUCT function with which you can use 2, 3 or more criteria with "or", "and"...SUMPRODUCT is like COUNTIF on steroids.