View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kayte Kayte is offline
external usenet poster
 
Posts: 3
Default count if (possibly?!)

Hi, I want to count how many people gave the answer "yes" to a given
question, but I want to summarise my data by area and by account name.

So, I want to know how many "Sovereign" customers in the "NW" said "yes".

A1:A1000 = "Sovereign"
B1:B1000 = "NW"
C1:C1000 = "yes"

Can anybody help? Thanks in anticipation...