sumproduct

[Guest]

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,

 

[Don Guillett]

try
=SUMPRODUCT((MONTH($E$8:$E$75)=1)*($e$8:$e$75<>"")

 

[Bob Phillips]

=SUMPRODUCT(--(ISNUMBER($E$8:$E$75),--(MONTH($E$8:$E$75)=1))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Thanks Don. Works great!
--
Dewayne

try
=SUMPRODUCT((MONTH($E$8:$E$75)=1)*($e$8:$e$75<>"")