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