ADDRESS and SUM

P

psych142

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
 
E

Elkar

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
 
R

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.
 
R

Ron Coderre

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
 
P

psych142

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