total of column

  • Thread starter Thread starter shlomop
  • Start date Start date
S

shlomop

I’m trying to make a check register, and I wont to make that the tota
of the balance column should be on top of the spreadsheet, the balanc
column is a total from each row and I need the last sell from thi
column should be on to
 
Hi
in A1 enter (if no blank rows are in between):
=OFFSET(A$2,COUNTA(A$2:A$1000)-1,0)
and copy this to the right
 
Back
Top