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


--
JasonUT
------------------------------------------------------------------------
JasonUT's Profile: http://www.excelforum.com/member.php...o&userid=16270
View this thread: http://www.excelforum.com/showthread...hreadid=276753

=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