formula that compares different ranges

S

sir Lancelot

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.
 
P

Peo Sjoblom

=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)
 
S

sir Lancelot

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