Thread: sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dewayne Dewayne is offline
external usenet poster
 
Posts: 49
Default sumproduct

I have the following formula in place to count the number of incidences by
the month.

=SUMPRODUCT(1*(MONTH($E$8:$E$75)=1))

The formula works for all of the months except January when it counts the
blank cells as a January incidence.
Any help in adjusting the formula so it does not count blank cells for
January would be appreciated.
Thank you,
--
Dewayne