hi, thanks for your help.

I had been trying this based on other posts but for some reason it's
returning '#value!' - a value used in this formula is of the wrong data
type...

"Paul B" wrote:

Kayte, see if this will do it,

=SUMPRODUCT((A1:A25="Sovereign")*(B1:B25="NW")*(C1 :C25="yes"))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Kayte" wrote in message
...
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...