How do I keep up with a monthly amount due from past years?

H

hotsytotsy79

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

Mike

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Calculating interest due on late loan payments 1
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Automation of scanned file storage based on content 0
Need to add cell value in every month 2
adding up time over & under a specified amount 3
convert existing range of dates to to current year, maintaining mm 4
I have lost 6 months work, how can i get my file back 1

Top