have an array start with a variable

[RenownedWolfman]

im trying to have an array start with a variable that i have already found in an ajacent cell so instead of going F:F go F(G5):F. (G5) Being the cell containing the variable.

[DGagnon]

you can do that with indirect, something like this

=SUM(INDIRECT("F1:F"&G5))

[RenownedWolfman]

Thank you for the quick responce but i can't seem to reverse it i need it to start at F(G5) not end at it i'm sure it's something simple but can't see it

[Paul]

Then perhaps...

=SUM(INDIRECT("F"&G5&":F100"))

If the last row is variable as well, replace it too.

=SUM(INDIRECT("F"&G5&":F"&G6))