Count # of Businesses
 

I have a simple spreadsheet that I have compiled using business
information. In this spreadsheet there are multiple businesses with multiple
employees. Can someone help with a formula that will give me the count of the
number of indivual business.

Example

Whicker Basket Inc John Smith
Whicker Basket Inc Sally Jones
Lollipop Corp. Joe brown
Lollipop Corp. Mark Johnson

There are 2 companies but 4 employees how do I count just the companies.

With the companies listed in Column A, try this:

=SUMPRODUCT((A1:A30<"")/COUNTIF(A1:A30,A1:A30&""))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"GGI Mark" wrote in message
...
I have a simple spreadsheet that I have compiled using business
information. In this spreadsheet there are multiple businesses with
multiple
employees. Can someone help with a formula that will give me the count of
the
number of indivual business.

Example

Whicker Basket Inc John Smith
Whicker Basket Inc Sally Jones
Lollipop Corp. Joe brown
Lollipop Corp. Mark Johnson

There are 2 companies but 4 employees how do I count just the companies.

"GGI Mark" wrote in message
...
I have a simple spreadsheet that I have compiled using business
information. In this spreadsheet there are multiple businesses with
multiple
employees. Can someone help with a formula that will give me the count of
the
number of indivual business.

Example

Whicker Basket Inc John Smith
Whicker Basket Inc Sally Jones
Lollipop Corp. Joe brown
Lollipop Corp. Mark Johnson

There are 2 companies but 4 employees how do I count just the companies.

Data - Filter - Advanced Filter and mark Unique Records to hide duplicated
company names
then in a blank cell, =subtotal(2,range) to count the remaining
visible rows.

Thank you I'm not sure how that formula worked but it did thanks.


G

"RagDyer" wrote:

With the companies listed in Column A, try this:

=SUMPRODUCT((A1:A30<"")/COUNTIF(A1:A30,A1:A30&""))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"GGI Mark" wrote in message
...
I have a simple spreadsheet that I have compiled using business
information. In this spreadsheet there are multiple businesses with
multiple
employees. Can someone help with a formula that will give me the count of
the
number of indivual business.

Example

Whicker Basket Inc John Smith
Whicker Basket Inc Sally Jones
Lollipop Corp. Joe brown
Lollipop Corp. Mark Johnson

There are 2 companies but 4 employees how do I count just the companies.