ExcelBanter - summing a table based on a cell reference?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - summing a table based on a cell reference? (https://www.excelbanter.com/excel-discussion-misc-queries/451500-summing-table-based-cell-reference.html)

Dave H

summing a table based on a cell reference?

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.

All times are GMT +1. The time now is 05:59 AM.