View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ardus Petus
 
Posts: n/a
Default 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