How can I make this work? I want the answer to be a number.

Column D contains individual names
Column G contains certain criteria.
I can count the criteria in column G with countif, but I only want it to
total if column D contains text data. For an example,
If d17 has no data, do not count what is in G17.

IDEAS???

See answer to your previous post, it is always better to wait a little while
to check answers to your post

--
Regards,

Peo Sjoblom

(No private emails please)


"sir Lancelot" wrote in message
...
How can I make this work? I want the answer to be a number.

Column D contains individual names
Column G contains certain criteria.
I can count the criteria in column G with countif, but I only want it to
total if column D contains text data. For an example,
If d17 has no data, do not count what is in G17.

IDEAS???

=SUMPRODUCT(--(NOT(ISNUMBER(D1:D100))),--(D1:D100<""),--(G1:G100="criteria"
))

--

HTH

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


"sir Lancelot" wrote in message
...
How can I make this work? I want the answer to be a number.

Column D contains individual names
Column G contains certain criteria.
I can count the criteria in column G with countif, but I only want it to
total if column D contains text data. For an example,
If d17 has no data, do not count what is in G17.

IDEAS???