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

sumproduct
 

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

--
Don Guillett
SalesAid Software

"Dewayne" wrote in message
...
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

sumproduct
 

=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)

"Dewayne" wrote in message
...
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

sumproduct
 

Thanks Don. Works great!
--
Dewayne


"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"Dewayne" wrote in message
...
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