SUMPRODUCT - Additional criteria
The formula below adds up the number of reports by the month.
=SUMPRODUCT((MONTH($E$8:$E$75)=1)*($e$8:$e$75<"")
I need to add additional criteria to the formula which includes the name of
the sales person. The end result needs to be the number of reports by month
by sales person.
Thank you for any help
--
Dewayne
|