Do you have any errors in any of those ranges?

Remember to look in any hidden rows (is autofilter on?)

And if that doesn't help, post the formula you tried.

Kayte wrote:

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




--

Dave Peterson