hi
i have small tables (lots of them) with the same column 'titles' but they can be in a different order - and i want to only have the column with the title 'total'.
i do not think i can sort all the rows by column (or alphabetical) order to resolve this (for example i could rename all 'total' titles as 'AAtotal' and do a sort alphabetically left to right to get the total column next to the number - does anyone know how to do that? and to do it for all the smaller tables).
Therefore think i might need to insert a column after number in order to say "give me the value that is in the column called 'total' - but i need to let the formula change as the column that contains total title will change as we go down the rows.
any help appreciated


number cat 1 cat 2 cat 3 total
123456 10 10 10 30
234567 20 20 20 60
345678 5 5 5 15


number cat 1 cat 2 total
567890 2 2 4
678912 3 3 6
78913 10 15 25

I am trying to get:

number Total
123456 30
234567 60
345678 15
567890 4
678912 6
78913 25