View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Janet Janet is offline
external usenet poster
 
Posts: 49
Default Excel count with 2 conditions

I'm sure this is an easy one for you but I just can't get it to work
correctly. I have a spreadsheet that I want to count certain criteria.
Example:
A B C
Name Gender Score
Calvin M 3
William M 4
Jessica F 1
Sarah F 3
Bryan M 1
Anna F 3

I need to how many females scored a 3. What would you suggest I use for a
formula?