In B3 and you are adding below that?

=SUM(B4:B65536)


Gord

On Fri, 30 Nov 2007 09:41:00 -0800, Wanna Learn
wrote:

Thank you My totals are in row 3

"Gord Dibben" wrote:

Where is the formula located?

Assuming in column B enter this in B23

=SUM(B4:INDEX(B:B,ROW()-1))

Inserted rows above this will be included.


Gord Dibben MS Excel MVP

On Fri, 30 Nov 2007 06:49:02 -0800, Wanna Learn
wrote:

Hello I have a daily report. Every day I add a new line. Presently I have
the formula =SUM(B4:B22) but every day I go in and change the formula to
include the next line. example tomorrow the the formula will read
=SUM(B4:B23) Is there a faster way to do this so that it automatically
updates without having to change the formula daily? thanks