Instead of placing Totals at the bottom, place them at the top of the data.
Then sum up the entire column.
Like in b2 have
=SUM(B3:B50000)
That you can keep adding data at the bottom without redoing the total formula.

"hotsytotsy79" wrote:

I need to be able to keep up with a monthly amount that goes back several
years due to someone.