count if (possibly?!)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 
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, 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...
 
Hi, thanks for your help. It's returning #value! - "a value used in this
formula is of the wrong data type".

(apologies for the late reply - for some reason my earlier reply didn't
appear!)
 
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.
 
Back
Top