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.