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