Sorry Josh, mis-read it.
Try this
=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 think the problem lies witht the fact that not every that needs to be
counted has data in all three (D,E, F) columns. Some only have data in
"D",
some in "D" and "E", and a rare "D", "E", and "F".
"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.
|