excel table

  • Thread starter Thread starter John Lanning
  • Start date Start date
J

John Lanning

I wish to create a simple table and enter numerical data
in column B with and automatic total, row by row, in
column C (for example using the formula =C5+B6)
I wish to be able to cut rows, re-arrange rows and add new
rows without affecting the formula. I have tried using F4
without success. Can anybody help please.
 
One way:

C1: =SUM(B$1:B1)

and copy down as far as necessary.

Obviously when inserting rows, you'll have to copy the formula to
the new rows.
 
Back
Top