Count columns that meet criterias

R

rich178806

Col A Col B
11 1
11 1
12 1
11 2
13 2
11 1

I need a answer of three. If column a =11 i need it to count column b and i have tried multiple functions and i cant seem to find the right one using excel 2010. Please Help!
 
R

rich178806

Col A Col B

11 1

11 1

12 1

11 2

13 2

11 1



I need a answer of three. If column a =11 i need it to count column b and i have tried multiple functions and i cant seem to find the right one using excel 2010. Please Help!

that would give me the sum of the column b if column a = 11 i need it to count the column there is no sum needed in this formula i know that for sure.
 
J

joeu2004

Col A Col B
11 1
11 1
12 1
11 2
13 2
11 1

I need a answer of three. If column a =11 i need it to
count column b [...] using excel 2010.

You need to count __what__ in column B when column A is 11?

I am guessing you want to count when B is 1, since you expect 3 to be the
answer.

If you not require Excel 2003 compatibility, try:

=COUNTIFS(A1:A6,11,B1:B6,1)

If you require Excel 2003 compatibility (saving the file as ".xls"), try:

=SUMPRODUCT((A1:A6=11)*(B1:B6=1))
 

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

Top