thedeadzeds
Active Member
- Joined
- Aug 16, 2011
- Messages
- 442
- Office Version
- 365
- Platform
- Windows
Hi Guys,
Is it possible to sum rows but exclude a column based on the name.
For example, sum everything in the below but exclude the 'Total Column'
The total column could be anywhere in the header row so will not always be in the same column
So the example below excludes 4785 from the sum
Thanks
Is it possible to sum rows but exclude a column based on the name.
For example, sum everything in the below but exclude the 'Total Column'
The total column could be anywhere in the header row so will not always be in the same column
So the example below excludes 4785 from the sum
Thanks
Column 1 | Column 2 | Total | Column 3 | Column 4 | Column 5 | Column 6 | Sum |
101 | 56 | 4785 | 414 | 41 | 54 | 47 | 713 |