Siamrooster
New Member
- Joined
- Oct 5, 2017
- Messages
- 5
Hi Mr. Excel forum,
Very grateful for any suggestions on how to achieve objective for this spreadsheet. Searched the forum for a while but don't even know how to categorize the question.
The objective is to be able to 'count' each store only 1 time, and to get a total 'sum' for each store. We need to know how many stores we are serving, and the volume for each one.
Of course the entire process can be done manually - sorting by store number, creating a new row - Sum of volume for the store - but this will take forever.
Thank you very much in advance!
Best regards
SR
StoreID Sales team code Total sales
273 X1 $2,000
273 X2 $3,000
273 X3 $1,500
273 X4 $600
645 X1 $4,000
645 X2 $300
645 X3 $250
645 X4 $1,600
921 X1 $900
921 X2 $2,400
921 X3 $1,300
Very grateful for any suggestions on how to achieve objective for this spreadsheet. Searched the forum for a while but don't even know how to categorize the question.
- The spreadsheet in question has 107,821 rows of data.
- Each row holds 1 years product volume for a given store.
- The challenge is that the data is organized by sales team, not by store.
- Therefore each store appears multiple times.
- The stores are identified by a unique code (this is a column).
- And the sales teams are identified by a unique code (this is a column).
- See data model below
The objective is to be able to 'count' each store only 1 time, and to get a total 'sum' for each store. We need to know how many stores we are serving, and the volume for each one.
Of course the entire process can be done manually - sorting by store number, creating a new row - Sum of volume for the store - but this will take forever.
Thank you very much in advance!
Best regards
SR
StoreID Sales team code Total sales
273 X1 $2,000
273 X2 $3,000
273 X3 $1,500
273 X4 $600
645 X1 $4,000
645 X2 $300
645 X3 $250
645 X4 $1,600
921 X1 $900
921 X2 $2,400
921 X3 $1,300