Counting occurrences of multiple conditions
 

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 the

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

Stick in yet another, if need be. And another.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jvanderv1" wrote in message
...
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!

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

"Earl Kiosterud" wrote:

J,

Just stick it in the

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

Stick in yet another, if need be. And another.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jvanderv1" wrote in message
...
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!