Running total....

  • Thread starter Jay.... Needing help
  • Start date
J

Jay.... Needing help

I am adding customers info on an Excelsheet... What I want to do is always
show a running total of Income for the month at the bottom of my sheet no
matter how large it gets.... how can I keep the total tab at the bottom even
as I add rows,
EX:


a;alsjkas 300.00 alskjdf;a asl;djkf; a;slfjkd

Total
600.00

basically I want to just add the info and the Total tab will automatically
adjust below the Rows of information....

Can this be done... please give me instructions, I'm a beginner user...

Thx~J
 
J

Jay.... Needing help

Jay.... Needing help said:
I am adding customers info on an Excelsheet... What I want to do is always
show a running total of Income for the month at the bottom of my sheet no
matter how large it gets.... how can I keep the total tab at the bottom even
as I add rows,
EX:


a;alsjkas 300.00 alskjdf;a asl;djkf; a;slfjkd

Total
600.00

basically I want to just add the info and the Total tab will automatically
adjust below the Rows of information....

Can this be done... please give me instructions, I'm a beginner user...

Thx~J
Click to expand...
 
J

J.Evans.1970

Jay,

It's really easy. Just pick the cell in the row you want to have your
running total. Put in the Sum Function. =SUM(B1:B8) Here we are
summing column B. The next time you insert a row above your total the
function will automatically change. If you insert 1 row, then it will
be =SUM(B1:B9). Once you enter your new number it will be summed up.
 
Top