Count Function Help

J

Josh O.

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.
 
B

Bob Phillips

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

--

HTH

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

Josh O.

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".
 
B

Bob Phillips

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