You could also generate a pivot table. If you use shortcuts, you can
generate this in less than 15 seconds
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"gls858" wrote:

CTAY wrote:
How can I count the number of stores per region?

Store # City


I want to see the results of Houston = 3 and Dallas = 2

another method would be to sort by store# or city and then use the
subtotal function and select count. The result would be something
like this

1 Houston
1 Houston
1 Houston
Houston Total 3
4 Dallas
4 Dallas
Dallas Total 2

gls858