Dynamic reference to Table Column header

Hi everyone,

I have some challenge to create a formula to get a reference to a table column header,

=SUMIFS(Table9[[#All],[ExtendedCost]], Table9[[#All],[Subscription Name]], A4, Table9[[#All],[Product]], "<>Apple")

Since I have multiple tables in different sheet named from "Table 1", Table 2", "Table 3", ... and all table structure/header are the same, and now I'm creating a summary on other sheet to get a total value based on the criteria based above, but wanna to change it to a reference rather than changing the Table Name each time manually when creating a new table.

Table Name: Table 9

ExtendedCost	Subscription Name	Product
$4.00	Sub1	Apple
$55.00	Sub2	Orange
$11.00	Sub3	Banana

Can someone guide me on that. Thanks and appreciated.

Try it like this:

=SUMIFS(INDIRECT(A1&"[[#All],[ExtendedCost]]"), INDIRECT(A1&"[[#All],[Subscription Name]]"), A4, INDIRECT(A1&"[[#All],[Product]]"), "<>Apple")

where A1 contains the text Table9.

Hope this helps.

Pete