counting blank cells within two columns

S

Shaun Merritt

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!
 
C

Claus Busch

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.
 
S

Shaun Merritt

The first one worked! Thank you!!!!


Hi Shaun,



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






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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top