View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
The Goose The Goose is offline
external usenet poster
 
Posts: 1
Default Comparing data from two columns

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!