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]

Let's say that your data above is in the range A1:G2.
Then you could use this formula to get your desired SUM:

=SUM(A2:G2)-INDEX(A2:G2,MATCH("Total",A1:G1,0))

 

[Fluff]

Another option

=SUMIFS(A2:G2,A$1:G$1,"<>Total")

 

[thedeadzeds]

Thank you both

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[thedeadzeds]

Another option

=SUMIFS(A2:G2,A$1:G$1,"<>Total")

Hi Fluff, I've been trying to figure out how to adapt this for more than column header. So exclude "Total" and "Bonus". Can you please help? Thanks

 

[Peter_SSs]

Try

=SUM(FILTER(A2:G2,(A1:G1<>"Total")*(A1:G1<>"Bonus"),0))

 

[Fluff]

Another option

=SUMIFS(A2:G2,A$1:G$1,"<>Total",A$1:G$1,"<>Bonus")

 

[thedeadzeds]

Thank you both

 

[Fluff]

Glad we could help & thanks for the feedback.