Sum of specific label matching from different column lables

[bkinbhills]

Need only sum of under "total" label values (answer 10000)

 

[Monty]

As an example

=SUMIF(A:A, "total", B:B)

 

[bkinbhills]

sorry, it is not correct
thanks

 

[Monty]

sorry, it is not correct
thanks

=SUMIF(C:C, "total", A:A) + SUMIF(C:C, "total", B:B)

 

[bkinbhills]

not working, here sum range and criteria range also are horizontal
i tried the same and got the answer but not working with next headers.
here need one formula that works with all headers

 

[pecoflyer]

Posting a sheet instead of a picture, with some expected results would really help

 

[bkinbhills]

Hi, PFA

 

[pecoflyer]

I don't get the logic, sorry.

 

[Juniad]

Check if its work for you?
Paste this formula in E2 and copy down.
=TEXT(INDEX(A2:C2,,IFERROR(MATCH("Total",A1:C1,0),MATCH("Total",$A$1:$C$1,0))),"#;;;")

 

[bkinbhills]

Wow, It is working
thanks