Tigerexcel
Active Member
- Joined
- Mar 6, 2020
- Messages
- 493
- Office Version
- 365
- 2019
- Platform
- Windows
Book7 | ||||
---|---|---|---|---|
B | C | |||
2 | Name | Sales | ||
3 | Tom | 10 | ||
4 | Tom | 20 | ||
5 | Tom Total | 30 | ||
6 | Nick | 40 | ||
7 | Nick | 50 | ||
8 | Nick | 60 | ||
9 | Nick Total | 150 | ||
10 | Grand Total | 180 | ||
Sheet2 |
Received a file of which I've extracted a small part of. Problem is everything is hardcoded.
Can I use INDIRECT to help total the values, something like SUM(INDIRECT(B5&"Total")) to pick up the respective subtotals and place the overall total in the Grand Total cell?
Is there a better way to work out totals and quickly make the spreadsheet dynamic so that rows can be added/removed and totals update automatically?