singingsister
Board Regular
- Joined
- Jun 13, 2006
- Messages
- 145
I have a spreadsheet which lists order placed by customers in a month. Every customer falls under an area code depending on where they are in the country i.e GB1, GB2, GB3 etc. At then end of every month, I have to produce a report showing all orders placed by the area codes.
At the moment, I have all the GB1 customers together, followed by the GB2 customers etc vertically, so at the bottom I can total the orders by simply using SUM. This means every time I want to add a "new" customer to the spreadsheet, I have to insert cells within the spreadsheet. This is time consuming as I have 5 different tabs for the 5 different factories!
What I want to do is not to have to worry about what order the customers are in the list (so I could maybe alphabetise them), but that for the totals at the bottom, Excel looks through the sheet and adds up all the values for the weeks for customers GB1 together, GB2 together etc.
The spreadsheet looks a bit like this:-
Area Customer Week 23 Week 24 Week 25 Week 26
GB1 P Smith $456.84
GB1 L Jones $45447.65 $45618.70
GB2 R Jenkins $46583.00
GB2 XYZ $778.49 $789.47
GB3 XYZ £159.45 $45694.87
GB4 XYZ $64456.77
GB6 XYZ $781.78
Can anyone help?
At the moment, I have all the GB1 customers together, followed by the GB2 customers etc vertically, so at the bottom I can total the orders by simply using SUM. This means every time I want to add a "new" customer to the spreadsheet, I have to insert cells within the spreadsheet. This is time consuming as I have 5 different tabs for the 5 different factories!
What I want to do is not to have to worry about what order the customers are in the list (so I could maybe alphabetise them), but that for the totals at the bottom, Excel looks through the sheet and adds up all the values for the weeks for customers GB1 together, GB2 together etc.
The spreadsheet looks a bit like this:-
Area Customer Week 23 Week 24 Week 25 Week 26
GB1 P Smith $456.84
GB1 L Jones $45447.65 $45618.70
GB2 R Jenkins $46583.00
GB2 XYZ $778.49 $789.47
GB3 XYZ £159.45 $45694.87
GB4 XYZ $64456.77
GB6 XYZ $781.78
Can anyone help?