G Guest Jan 10, 2006 #1 How can I enter a formula in excel that counts two text clauses. For instance: If range A1:A50=John AND range B1:B50=Smith, count 1?
How can I enter a formula in excel that counts two text clauses. For instance: If range A1:A50=John AND range B1:B50=Smith, count 1?
B Bob Phillips Jan 10, 2006 #2 =SUMPRODUCT(--A1:A50="John"),--(B1:B50="Smith")) -- HTH Bob Phillips (remove nothere from email address if mailing direct)
=SUMPRODUCT(--A1:A50="John"),--(B1:B50="Smith")) -- HTH Bob Phillips (remove nothere from email address if mailing direct)
