Count occurrences when two conditions are met

  • Thread starter Thread starter Steve
  • Start date Start date
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,
 
Use =SUMPRODUCT()

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

Alwasy consider SUMPRODUCT when you have moe than one criteria.
 
Back
Top