Count Function Help
 

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.

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

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.

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.

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.