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.