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.

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.

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.

Hi,

If your data looks like this
A B
Company1 Contact1
Company1 Contact2
.....

=COUNTIF(A:A,"Company1")

or better yet, enter all the company names in C1:C10 and

=COUNTIF(A:A,C1)

and copy down.

If this isn't what you want then you will understand why it is important to
supply us with samples.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


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

try using Countif
eg =COUNTIF(A:A,"abc")

abc is the company name
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










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