View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dewayne Dewayne is offline
external usenet poster
 
Posts: 49
Default 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