I tried that formula, but the result is always "0". I am not sure why.

"Bob Phillips" wrote:

=SUMPRODUCT(--(D1:D1000<""),--(E1:E1000<""),--(F1:F1000<""),--(H1:H1000="
"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Josh O." wrote in message
...
I am trying to create a function to count the number of proofs out to the
customer...

I have the following columns:
...| D - OOP1 | E - OOP2 | F - OOP3 |...| H - Ok |

I need to count any rows that have data in columns D, E, or F (could be
dat
in one column, 2, or all 3, or none at all), but blank in H.

I have tried it a few different ways, but I just get a "0" answer.