Dear [EMAIL PROTECTED],
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;2;1):C8)
This does not work: =+SUM(CONCATENATE("$C$";F4):C8)
What do I do? Please give me an example.
Here is a small Calc spreadsheet, feel free to download it, change it and
upload it.
Link to file: http://www.mytempdir.com/2039366 << If clicking on this link
does not work, then
please copy and paste this into your browser address field.
Then, please let me know the mytempdir file number, for what you upload.
Thank you,
John Gilchrist
