SUM INDEX MATCH - Help Please

[Tommyslats]

Hi,

I need to sum a row of cells based on a value which corresponds to a column header.

Screen Shot 2022-03-09 at 11.33.35 am.png

Looking at the example above.
based on the values in Column A, I need to SUM the cells to the right of the column that corresponds with the number in column A.

I marked my required values in yellow to the right.

Thanks,

[TMS]

Try:

Please Login or Register  to view this content.

copied down.

[AliGW]

Or this:

=SUMIF($B$1:$M$1,">="&$A3,$B3:$M3)

[wk9128]

Cell O3 formula , Drag down

Please Login or Register  to view this content.