Need to count cells in Column1 where each cell's row also hasspecified value in Column2

[bcnewell]

Hi all, I've tried searching for an answer, but haven't found exactly what I'm looking for. Any help on writing this formula would be wonderful.

I need to count the number of rows where cell A1 has a value of "value1" AND cell A2 has a value of "value2".

For example, I want to be able to count how many of my survey respondents answered, in cell A1 (age) "25-34" AND where those same respondents also answered "Female" in cell A2.

Thus if 100 respondents said "25-34" in A1, and 50 of those 100 also said "Female" in A2, then the count should return "50".

If I can figure this out, I'd like to add another limiter in, to count the number of rows where, e.g., A1="25-34" AND A2="Female" AND A3="Liberal".


Thanks in advance!

 

[Claus Busch]

Hi,

Am Mon, 27 Jan 2014 17:26:48 -0800 (PST) schrieb (e-mail address removed):

For example, I want to be able to count how many of my survey respondents answered, in cell A1 (age) "25-34" AND where those same respondents also answered "Female" in cell A2.

Thus if 100 respondents said "25-34" in A1, and 50 of those 100 also said "Female" in A2, then the count should return "50".

try:
=SUMPRODUCT(--(A1:A100>=25),--(A1:A100<=34),--(A2:A101="Female"))


Regards
Claus B.

 

[bcnewell]

Thank you Claus! Worked like a charm.

Hi,



Am Mon, 27 Jan 2014 17:26:48 -0800 (PST) schrieb:






try:

=SUMPRODUCT(--(A1:A100>=25),--(A1:A100<=34),--(A2:A101="Female"))





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2