ADDRESS and SUM

[Guest]

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

 

[Guest]

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

 

[Roger Govier]

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.

 

[Guest]

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

 

[Guest]

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