Comparing data from two columns

T

The Goose

I have two columns of unique data, and I am trying to have Excel count the
number of instances that a cell from Column A = X and the cell from the same
Row in Column B = Y (without adding columns).

In other words, if Column A = Local or National and Column B = Paid or
Unpaid, is there a formula that will evaluate both columns and show me how
many Local Unpaid accounts I have?
 
E

Eva

See the formula

=SUM(IF($B$4:$B$8="lokal",IF($A$4:$A$8="unpaid",1,0),0))
When you apply this formula click ctrl+shift+enter (in the status bar)
assuming
column A = pmt, Col B=Lokal/national
range:A3:b8
Eva
 
T

T. Valko

One way...

=SUMPRODUCT(--(A1:A10="local"),--(B1:B10="unpaid"))

Better to use cells to hold the criteria.

D1 = local
E1 = unpaid

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1))

If you're using Excel 2007...

=COUNTIFS(A1:A10,"local",B1:B10,"unpaid")

=COUNTIFS(A1:A10,D1,B1:B10,E1)
 

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