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

B

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!
 
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Fill cells increment row number i fomula 1
How to get cell coordinates? 3
Need a UDF to count blank cells 5
Count cells in range 3
finding range of numbers in one row to another row 5
Counting unique values in a row 8
Function to format a value into percent with no decimal 3

Top