At 10:51 13/10/2007 -0500, John Gilchrist wrote:
How do I calculate the coordinate in an address range?
For example, I want to calculate $C$4 and place it into =+SUM($C$4: C8).
I am able to calculate $C$4 with ADDRESS or CONCATENATE,
but then I am unable to embed this calculated result inside of SUM().
This does not work: =+SUM(ADDRESS(F4;3;1):C8)
But this does:
=SUM(INDIRECT(ADDRESS(F4;3;1)&":C8"))
This does not work: =+SUM(CONCATENATE("$C$";F4):C8)
But this does:
=SUM(INDIRECT(CONCATENATE("$C$";F4;":C8")))
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
