Count occurrences when two conditions are met

S

Steve

One column contains names. the other numbers. I'd like to count the number
of times two conditions are met. e.g., how many times does the name Smith in
column A come up with the number 90 in column B. Thanks,
 
G

Gary''s Student

Use =SUMPRODUCT()

=SUMPRODUCT((A1:A1000="Smith")*(B1:B1000=90))

Alwasy consider SUMPRODUCT when you have moe than one criteria.
 

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

How to count the numbers in a Word document? 0
countif with multiple conditions 5
Count if two arguments met 1
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 3
List all tables, including document structure 0
formula to count occurrences using multiple columns 2
SUMPRODUCT help with dates 4
Two Condition Vlookup 1

Top