software

Hi,
I have a list of contact information. One of the columns is for the email
address. I want to know how many rows in that column are empty. This is
the formula I tried:

=count(if L7:L2113=quot;quot;)

That just gives me zero, and I know there are rows that don't have an email
address.

What formula do I need?

Thanks,

Dan
Never mind...I got it.....=countif(L7:L2113,quot;quot;)

quot;Dan Bquot; gt; wrote in message
...
gt; Hi,
gt; I have a list of contact information. One of the columns is for the email
gt; address. I want to know how many rows in that column are empty. This is
gt; the formula I tried:
gt;
gt; =count(if L7:L2113=quot;quot;)
gt;
gt; That just gives me zero, and I know there are rows that don't have an
gt; email address.
gt;
gt; What formula do I need?
gt;
gt; Thanks,
gt;
gt; Dan
gt;
gt;