Sum all rows above
Hi Robert,
Try:
=SUM(OFFSET(A1,,,ROW()-1,1))
HTH
--
AP
"Robert" a écrit dans le message de news:
...
I want to put into a cell the total of all numbers above that cell in that
column. I want to do this without specifying specific rows. In this way,
if a row were added above the total, it would be included in the total
correctly.
Robert
|