Adding columns based on start column and number of columns...

Hi,

I want a formula that adds each column from Start to a specified number of columns.

So:

Number = 2

S
1 2 3 4
A 1 2 3 = 5
B 1 2 3 = 5
C 1 2 3 = 5

So if we start at column 3 and the number is 2 then it would show as above or:

Number = 2

S
1 2 3 4
A 1 2 3 = 3
B 1 2 3 = 3
C 1 2 3 = 3

If we start at column 2 and the number is 2 then it would be as above this.

Or:

Number = 1

S
1 2 3 4
A 1 2 3 = 2
B 1 2 3 = 2
C 1 2 3 = 2




I hope that makes sense!

Thanks, I actually solved it using CELLK5 =SUM(OFFSET(A3,2,(MATCH("Start",$A$3:$J$3,0)-1),1,$K$3))

Capture.PNG