View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shaun Merritt Shaun Merritt is offline
external usenet poster
 
Posts: 2
Default counting blank cells within two columns

Forgive me if this has been asked before, but I cannot find an answer that works within my situation.

I have an excel database (address book) that has two columns that I need help with. One column is for a primary email address and the second column is for a secondary email address.

They are columns A and B and there are 394 rows in each column.

So the info I am searching through is A:1-A:394 and B:1-B:394.

I need a formula that will count how many rows within the two columns are blank... ignoring any row that has at least one email address.

I know how to do it for a single column, but I am lost on how to make it count two columns as one.

Any help would be much appreciated.

Thanks!