Create summary of quantities by an interval

THANK YOU!!!

Attached is a sample data file.

The worksheet Raw Data contains a column, Number, that is just a sequential number from 1, to a variable ending number. The column Store contains one of a variable number of possible names. I am only interested in 3 specific Store names: smith, jones, and brown.

I'd like to be able to create the Summary Data worksheet that is shown. However, in what I've shown I listed the interval 301 - 400 as the last interval of interest; in reality, I'd like to have a formula (or macro?) to determine the last interval. I'd also like to fill each cell in that table with the number of occurrences of the specified store in the specified interval.

I hope I'm being clear.

What is the best way to do this?