Hi Kayte,

use:

=sumproduct(--(a1:a1000="Sovereign")*(b1:b1000="NW")*(c1:c1000=" Yes"))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Kayte" escreveu:

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...