View Single Post
  #1   Report Post  
Wenster
 
Posts: n/a
Default Count number of occurences in 1 column only if something in anothe

I want to do a count the number of occurences with in 1 column, only if there
is a specific number in another column.

Ex: A1:A6 contains male or female
B1:B6 contains that persons answer to Question1 (either a 1 for yes or a 2
for no)

I want to count the number of males that answered yes to Question1

Is this possible?