I’ve 4 months of monthly cash sales for a product which is sold in various outlets which belong to specific territories. There are about 200 territories and multiple outlets in each territory. I’d like to sum the sales for each outlet within its territory and rank the outlets by the volume of sales in their territory.

What do you think of the approach below, is it good, I’ve got that funny feeling im making hard work of it:

List Unique Territories in Sheet(“Lists’”) column A
List Unique Outlets in Sheet(“Lists”) in column B

For each Territory in Sheet2.Range1
For each Outlet in Sheet2.Range2
Sum Sales in Sheet(“RawData”) and place Territory/Outlet/4 months sales figure in Sheet(“Results”)
Next Outlet
Next Territory

Then rank the outlets by adding a column in Sheet(“Results”) with a score of 1 for the highest sales to 10 or greater (depending on number of outlets in the territory, which varies).