Thread: count if
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scooter Scooter is offline
external usenet poster
 
Posts: 43
Default 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.