LinkBack URL
About LinkBacks
I'm trying to do something along the lines of:
SUM($A$1:'CURRENT CELL')
I dont want to just define it as A2, A3, etc. because its linked to another sheet
Is there a formula that returns the current cell?
I'm trying to do something along the lines of:
SUM($A$1:'CURRENT CELL')
I dont want to just define it as A2, A3, etc. because its linked to another sheet
Is there a formula that returns the current cell?
Last edited by themachine; 07-14-2010 at 09:44 AM.
That would be a circular reference if the range the cell was summing included itself, right?
Entia non sunt multiplicanda sine necessitate
oops sorry I meant something along the lines of:
SUM($A$1:OFFSET(CURRENTCELL,a,b,))
how would you identify the current cell?
I use a defined name. Select cell A1 and define Me refers to =A1 (no dollar signs)
=SUM($A$1:OFFSET(Me, a, b))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks