count G4:G51 for critera only if D4:D51 contains text data
 

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???

count G4:G51 for critera only if D4:D51 contains text data
 

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???

count G4:G51 for critera only if D4:D51 contains text data
 

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