Find column and use it in a formula

Hello!
I have trouble to come up with a formula. I have a data base that is downloaded from a system, each time the order of the columns is different.

I need to formulate, for example the sum of the number of "Tables", i.e. column B, so it would be =sum(b:b). This does not work for me because maybe next time the column with information about Tables is another different from B.

Capture.JPG

So I need a formula that identifies in which column is the information needed and that can be inside of another calculation formula. E.g. =sum(b:b) ,substitute b:b with a formula that identifies the column.

I though of using =match("tables",2:2,0) ,it would show is column #2 and then insert it into the formula I need, but I don't know how.

Any ideas would be very appreciatted!

This formula may work for you. The first range is the header row, and the second range is the data range. Adjust your ranges as needed.

Formula:

Please Login or Register  to view this content.

Note: This sums the column of values for the string Tables, it doesn't act as a pointer to that column.

Thank you very much for your help!

Now let me change the question. I need for example to bring to cell D7 the #erasers that Peter Wilson has.
I am using formula: =INDEX(A1:E5,MATCH(1,(A:A=A7)*(E:E=B7),0),MATCH(C7,1:1,0)) Ctr + Shift
What if every time I download the information the columns are in different order? is there a way to find in which column is the information of Name and substitute it for A:A?

Capture.JPG