Use cell ref in table formula

[Marcster]

I have the following formula:

=SUMIF(Table1[Column1],A5,Table1[[#All],[Column2]])

I would like the [Column2] part of the formula (Sum_range) to reference and use a cells value, example, if cell
A10 = AnotherColumn
I would like that in the formula.
This would mean I can get the Sum_range part of the table formula to be dynamic.

Thanks,

[大灰狼1976]

Hi Marcster!
Suppose the value of A10 cell is 3, this formula can summarize column3.
=SUMIF(Table1[Column1],A5,INDIRECT("Table1[[#All],[Column"&A10&"]]"))

[大灰狼1976]

Change #All to #Data, otherwise the result is wrong.

[Marcster]

Thank you, spot on :-)