Selection of Excel table column based on a header

Hey guys,

So I attach a sample file where I have a table that acts as the database for recording country and continent wise output of various products. Based on this table, I have another table which gives the continent wise output of the products. Now, the database table is an excel table and products either have names (Maize, Cheese, etc) or number (21,22,etc)
The user has an option to choose the continent based on which the results table should choose the column of the relevant product and produce the sum for that continent (clearer in the sample)

I use the formula

=SUMIFS(INDEX(TabOutput;0;MATCH(A14;TabOutput[#Headers];0));TabOutput[Continent];$A$11)

which works brilliantly for products with names (Maize) but fails terribly for those with nos (21). Could someone kindly explain this to me please and also how to resolve it? Thanks a bunch!variable table column selection.xlsx

Regards,
Alpana SAVARNA

Brilliant!
That seems to work. Thanks! I didn't know that concatenating "" with something converts the something into text.

Have a great day Ron.