Sum all rows above
One more.
If your formula is in A101:
=sum(a1:offset(a101,-1,0))
Robert wrote:
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
--
Dave Peterson
|