Sum calculation but exclude specific column name

[thedeadzeds]

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

Column 1	Column 2	Total	Column 3	Column 4	Column 5	Column 6	Sum
101	56	4785	414	41	54	47	713

 

[Joe4]

Note that when you are marking "Solutions", you should mark the solution to the original question, not to related follow-ups.
Otherwise, if people were to view this thread, and were to look just at the orignal question, and then the marked solution, it won't make much sense.