Using ADDRESS results in a LOOKUP_ARRAY

With the formula "ADDRESS" I calculated two references to two different cells. How can I use these results in the "lookup_array" in other formulas?

For example, I calculated A1 and A5 using ADDRESS.
Now I want Excel to calculate the total of cells A1 to A5 using the two ADDRESS results. How do I enter this in the "SUM" formula?

Please advise!

You could use the INDIRECT function to refer to the result returned by address, e.g. INDIRECT(ADDRESS(5,1))

......but using ADDRESS almost always isn't the best way, how are you deriving the cells using ADDRESS?

Use INDIRECT.

For example, if a "normal" formula looks like this:
=SUM(A1:A2)

With indirect, it looks like this:
=SUM(INDIRECT("A2:A3"))

In your case, you have some other function (let's call it "xyz") which returns "A1", and another function (let's call it "abc") which returns "A2". So, your SUM function now looks like this:
=SUM(INDIRECT(xyz&":"&abc))

Thanks guys!

the "=SUM(INDIRECT(xyz&":"&abc))" suggestion is what I was looking for.