The INDIRECT function should be what you're looking for. Let's say your
formulas that return your 2 cell addresses are in A1 and A2. Then use this
formula:

=SUM(INDIRECT(A1&":"&A2))

This provides the sum of the range indicated by the cell references in A1
and A2. You could also incorporate your original formulas inside of the
INDIRECT function. Something like:

=SUM(INDIRECT(yourformula1&":"&yourformula2))

HTH,
Elkar


"psych142" wrote:

Hi, have used an amalgamation of ADDRESS and MATCH to gain 2 cell addresses,
how do i then get sum to add the 2 cell addresses?

Cheers for your help in advance