Thank you, Very helpful, have been struggling over this for the past couple
of days. problem solved.

"Peo Sjoblom" wrote:

=SUMPRODUCT(--(ISTEXT(D4:D51)),--(G4:G51="."))

or if you by text means cells hold anything but blank

=SUMPRODUCT(--(D4:D51<""),--(G4:G51="."))

--
Regards,

Peo Sjoblom

(No private emails please)


"sir Lancelot" wrote in message
...
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.