I need a formula that finds criteria in a range if a different range contains
text data.
I already use countif
EXAMPLE:
=countif(g4:g51,".")
now I need that formula to work only if (D4:D51) contains text data.