Hi,

Assuming your data is in range A1:B6 as follows:

Branch Group
Delhi Marketing
Mumbai Finance
Calcutta Operations
Mumbai Marketing
Mumbai Operations

Enter the Marketing in cell A8 and enter the following array formula
(confirmed by Ctrl+Shift+Enter) in cell B8.

=ROUNDUP(SUM(IF(($B$1:$B$6=$A8),1/COUNTIF($A$1:$A$6,A1:A6),0)),0).

Hope this helps.


--
Regards,

Ashish Mathur
www.ashishmathur.com
http://www.linkedin.com/in/excelenthusiasts

"John" wrote in message
...
I have been up and down trying to find a answer but no luck.

I have a spreadsheet that contains all the employees for the company. One
column lists the branch where the employee sits, and another lists the
market
group they belong to. I need a formula that counts how many locations are
in
that market group.

Any ideas?

Using Excel 2003.