Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) | Excel Discussion (Misc queries) | |||
Counting Non Blank Cells | Excel Discussion (Misc queries) | |||
Counting Non Blank Cells | New Users to Excel | |||
Counting non-blank cells | Excel Discussion (Misc queries) | |||
Counting blank cells | Excel Programming |