=SUM(OFFSET(F1,0,0,ROW()-1))
would sum all numbers from F1 up to the cell in F where you enter the
formula.
JasonUT Wrote:
Hi,
I am trying to create a SUM function that will add SUM(X:Y) where X is
the Cell below the cell that contains the SUM solution and Y is the
cell above the first blank cell in the column. The X address is easy,
but the Y address always various depending on the days work.
I know this has got to be fairly straight forward, but I can't figure
it out.
Thanks,
Jason
--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread:
http://www.excelforum.com/showthread...hreadid=276753