LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) foofoo Excel Discussion (Misc queries) 3 February 20th 12 08:03 PM
Counting Non Blank Cells Lindsey Excel Discussion (Misc queries) 4 April 8th 09 06:41 PM
Counting Non Blank Cells AJ[_2_] New Users to Excel 6 March 27th 08 11:06 PM
Counting non-blank cells Joe M. Excel Discussion (Misc queries) 7 July 23rd 07 09:36 PM
Counting blank cells Kevin G[_2_] Excel Programming 1 February 6th 04 07:53 AM


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"