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

"The Goose" wrote:

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?

--
Thanks for your thoughts!