For some reason the original post isn't showing in Google Groups, so
I'll have to reply to Glenn's.

If every contact has an email address, then perhaps you could use
something like this:

=SUMPRODUCT(--(LEN(E1:E100)-LEN(SUBSTITUTE(E1:E100,"@",""))))

assuming email addresses are in column E, with maybe more than one per
cell.

Hope this helps.

Pete


On Mar 2, 4:32*pm, Glenn wrote:
got2email wrote:
I have a customer spreadsheet that includes a column for company name and
columns for contact information such as first name, last name, email address.
*Each company can have many contacts. *Each contact must include company name.

I would like to count how many contacts per company. *I tried all sorts of
Count and CountA expressions but no luck. *

Any help is greatly appreciated.

Show an example of your data and someone will be able to help you.