The Idea Dude
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 591
- Office Version
- 2016
- Platform
- Windows
Hi All,
If I have heaps of sheets with values in the same position on each sheet is there a way to tally them all on another sheet, the catch is, can I specify which sheets to add.
EG, if I have Sheet 1 all the way through to Sheet 100, and Sheet SUMMARY will be the totaling sheet can i somehow choose to total only sheets 10 to 20 and 35 to 47 and 91 to 99 (for example).
I realise on a smaller scale I could use sumif but I know it only nests to 7 or so.
Awaiting any help.
Thanks
If I have heaps of sheets with values in the same position on each sheet is there a way to tally them all on another sheet, the catch is, can I specify which sheets to add.
EG, if I have Sheet 1 all the way through to Sheet 100, and Sheet SUMMARY will be the totaling sheet can i somehow choose to total only sheets 10 to 20 and 35 to 47 and 91 to 99 (for example).
I realise on a smaller scale I could use sumif but I know it only nests to 7 or so.
Awaiting any help.
Thanks