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!

counting blank cells within two columns
 

Hi Shaun,

Am Wed, 21 May 2014 11:09:56 -0700 (PDT) schrieb Shaun Merritt:

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.

try:
=COUNTIFS(A1:A394,"=",B1:B394,"=")
or
=SUMPRODUCT(--(LEN(A1:A394)=0),--(LEN(B1:B394)=0))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

counting blank cells within two columns
 

The first one worked! Thank you!!!!


On Wednesday, May 21, 2014 1:19:25 PM UTC-5, Claus Busch wrote:
Hi Shaun,



Am Wed, 21 May 2014 11:09:56 -0700 (PDT) schrieb Shaun Merritt:



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.



try:

=COUNTIFS(A1:A394,"=",B1:B394,"=")

or

=SUMPRODUCT(--(LEN(A1:A394)=0),--(LEN(B1:B394)=0))





Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional