Comparing data from two columns

[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?

 

[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. 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)