Counting occurrences of multiple conditions

[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!

 

[Earl Kiosterud]

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.

 

[Guest]

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