Sum over a variable column - defined by the first row

[fab54]

Hi all,
Here is my issue:

I have few columns (let's say 10). In the first row of eacj column I have the name of a category (e.g. Cat A, Cat B, Cat C, etc) and below I have a bunch of numbers.

I would like to create a summary sheet where I add the numbers for each category.
The category only appears in one column but the problem is that the categories are not in a fixed column and could be in a different order.

Ideally, to get the total for Cat A I would like to use a MATCH() function to determine in which column Cat A is and them use the SUM() over that column. However I don't know how to combine these two functions.

Any ideas?

Many thanks for your help

 

[xld]

Try

=SUM(INDEX(A:J,0,MATCH("Cat A",1:1,0)))

 

[fab54]

It works!!!
Many thanks xld!!