I need to be able to keep up with a monthly amount that goes back several years due to someone.
H hotsytotsy79 Jul 18, 2005 #1 I need to be able to keep up with a monthly amount that goes back several years due to someone.
G Gordon Jul 18, 2005 #2 hotsytotsy79 said: I need to be able to keep up with a monthly amount that goes back several years due to someone. Click to expand... Work harder?
hotsytotsy79 said: I need to be able to keep up with a monthly amount that goes back several years due to someone. Click to expand... Work harder?
M Mike Jul 18, 2005 #3 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.
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.
