formula that compares different ranges

[Guest]

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 (D451) contains text data.

 

[Peo Sjoblom]

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

or if you by text means cells hold anything but blank

=SUMPRODUCT(--(D451<>""),--(G4:G51="."))

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

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