Count occurrences when two conditions are met
 

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,

Count occurrences when two conditions are met
 

Use =SUMPRODUCT()

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

Alwasy consider SUMPRODUCT when you have moe than one criteria.
--
Gary''s Student - gsnu200860


"Steve" wrote:

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,