Total column daily

[Wanna Learn]

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

 

[Stephen]

Do you have anything else in column B? If not, just use
=SUM(B:B)

 

[Gord Dibben]

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

 

[Wanna Learn]

Thank you My totals are in row 3

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

 

[Gord Dibben]

In B3 and you are adding below that?

=SUM(B4:B65536)


Gord