dynamic sum column based on header

[daveyc18]

i have this forumla

SUM('Leadsheet - Unclaimed Dividends'!K:K)/1000

but, im afraid that the relevant data in column K might be moved ...the header in column K is "Unreconciled Long Position Value"

next month this "Unreconciled Long Position Value" column could be in, say, column L

is there a way to make this dynamic?

 

[Cubist]

You can try this, however, I don't recommend using the entire column.

=SUM(CHOOSECOLS('Leadsheet - Unclaimed Dividends'!A:Q,XMATCH("Unreconciled Long Position Value",'Leadsheet - Unclaimed Dividends'!A1:Q1)))/1000