need help with count formula..

D

Dan B

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="")

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
 
Top