Sum previous cell? Insert line....
 

Hi Nuno

Enter this in cell E21 to sum cells from E2:E20
=SUM(E2:OFFSET(E21,-1,0))

--
XL2002
Regards

William


"Nuno" wrote in message
...
Hi.

I want to make cells of a columm, sum the cell in top of
itself. (im in c13... =sum (c12) and so on..)

when i insert a row (wich i have to) the cell doesn´t sum
the previous (on top) cell, it sum 2 cells up. and when i
delete that row it gives me #ref.

How can i do this!! i have to make SUM based on the
value of the cells in that row. (Sumif)

Thanks!