Counting occurrences of multiple conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I count the occurrences of more then 2 conditions? I have a formula
for 2 conditions "=sumproduct(($a$2:$a$500="list 1")*($b$2:$b$500=95))" that
formula finds "list 1" in the range a2-a500, it then checks for "95" in the
range b2-b500 and calculates the number of rows that contain both. I need to
add one more into the mix. any thoughts?

thanks in advance!
 
J,

Just stick it in there:

=SUMPRODUCT($a$2:$a$500="list 1")*($b$2:$b$500=95)*(C2:C500=whatever))"

Stick in yet another, if need be. And another.
 
Thanks Earl,

I did that but it did not work, it gave me the wrong number so I thought it
was a bad formula. I will look at the formula more carefully.

Jimv
 
Back
Top