Excel Formula with two clauses

G

Guest

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

=SUMPRODUCT(--A1:A50="John"),--(B1:B50="Smith"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting with a condition disregarding errors 7
Using two formulae 3
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
CountIf & multiple criteria 1
Conditional formatting a range of cells 3
Conditional countif 6
Countif with Dynamic date ranges. 2
Counting non blanks different from "" 4

Top