count if
 

I am looking to count the number of times a value(ie "3") appears in one
column only if the column next to it has a different specific value(ie
"bob").
column value1 value2
12 3 tim
13 3 tim
14 2 tim
15 3 bob
16 4 bob
17 3 bob
So in this case, it would count 2.

count if
 

Try something like this:

...........A..........B
1........2.........Bob
2........3.........Tim
3........3.........Bob
4........1.........Bob
5........3.........Bob

=SUMPRODUCT(--(A1:A5=3),--(B1:B5="Bob"))

--
Biff
Microsoft Excel MVP


"scooter" wrote in message
...
I am looking to count the number of times a value(ie "3") appears in one
column only if the column next to it has a different specific value(ie
"bob").
column value1 value2
12 3 tim
13 3 tim
14 2 tim
15 3 bob
16 4 bob
17 3 bob
So in this case, it would count 2.