Formula to reference table column

[Jetx227]

Hi all!
I'm not great with formulas so I was looking for some help on this. I have a table (call it table1) and I have a cell that has a formula that references the sales columns within the table (because of the way the sales work, there are multiple sales columns, lets call them "Sales Total", "Sales 1", "Sales 2", and "Sales 3". I have a cell (D4) on my worksheet that allows the user to choose "All", "1", "2", or "3". Right now, the formula I have uses a long SUMIFS statement, basically checking that if the uses chooses "1", then sum from "Sales 1", etc. Is there a way to make this formula shorter and somehow use the text from D4 (the user chosen value) to reference the column? ie: "Sales " & D4 or something? Thanks

 

[Jetx227]

Just want to let anyone who was curious that I figured it out by using the INDIRECT() function. So an example formula, if I wanted to sum the table column that the user chose would be (note, D4 is where the user's choice is):

=SUM(INDIRECT("Table1[Sales " & $D$4 & "]"))

Credit to this article:
Indirectly Refer to Table Columns