Help with SUM and INDIRECT Function

[Kinez101]

I want to sum Sheet22 using Variable Range on Sheet3 on Sheet 1...I am not sure how to use SUM and INDIRECT formula...I have given it a try. See attached. Any help is welcomed. Thanks.

[Jonmo1]

Try
=SUM(INDIRECT("'Sheet2'!A1:" &var_b&"1"))

[daddylonglegs]

Try this version

=SUM(INDIRECT("Sheet2!A1:"&var_b&"1"))

[Kinez101]

Worked. Thanks.

[Jonmo1]

You're welcome.