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

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

Hi

Presumably you mean to add the contents of the 2 addresses.
Why not post exactly what you are trying to achieve with an example of
the type of data, as there is probably a way to achieve what you want
without using Address.

--
Regards

Roger Govier


"psych142" wrote in message
...
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

It seems like you may be overcomplicating your process.

If you describe what you're doing and give examples of your formulas we may
find a more efficient approach.

***********
Regards,
Ron

XL2002, WinXP


"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

i was overcomplicating myself, i found a much quicker and easier way of doing
things, thanks for the replies :)

"Ron Coderre" wrote:

It seems like you may be overcomplicating your process.

If you describe what you're doing and give examples of your formulas we may
find a more efficient approach.

***********
Regards,
Ron

XL2002, WinXP


"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