COUNT, COUNTIF Counting Help Please

[Aladin Akyurek]

You might want to build a pivot table from your data.

 

[Nancy]

Greetings:

I have several spreadsheets that I need to get data counts on. The rows are
names and addresses with a 3 digit store number in each row. There are a
total of 112 different store numbers (125, 323, 442,...). There are over
10,000 rows in each file. Not all store numbers are used in all files
(varies).

I can use =COUNTIF(H2:H5982,580) to tell me how many records are for store #
580. Is there a way that I can get a listing of each store number with the
number of records associated with that store number without doing a lot of
manual work?

Any pointers would be greatly appreciated!

Thanks!
nan