I am pretty sure I could find the answer if I knew how to ask the question correctly but I can't seem to find it.

This works =SUM(Table1[[#All],[ColumnX]])
what I want to do is replace ColumnX with a cell reference say A5

what is the correct way to do that?

Thanks for your help.