Sum a dynamically-defined range

[Hershmab]

I have a series of cells containing the defining limits of a range, i.e.:
-sheet name
-top row number
-top column number
-bottom row number
-bottom column number

How do I sum (or otherwise operate on) the array so defined? I have tried
formulae containing combinations of various ADDRESS and INDIRECT functions,
but have not yet come across one that works.

 

[Jacob Skaria]

Try the below with

A1-sheet name
A2-top row number
A3-top column number
A4-bottom row number
A5-bottom column number


=SUM(OFFSET(INDIRECT("'" & A1 & "'!A1"),A2-1,A3-1,A4-A2+1,A5-A3+1))

 

[Luke M]

Using these references:
A1> -sheet name
a2> -top row number
a3> -top column number
a4> -bottom row number
a5> -bottom column number

This formula will genearte a summation of the dynamic range:
=SUM(OFFSET(INDIRECT("'"&A1&"'!"&ADDRESS(A2,A3)),,,A4-A2+1,A5-A3+1))

 

[Niek Otten]

=SuM(INDIRECT(A1&"!R"&A2&"C"&A3&":R"&A4&"C"&A5,FALSE))