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
|