Thread: Sum a column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefanie Stefanie is offline
external usenet poster
 
Posts: 6
Default Sum a column

Col A Result of Formula
1 0 0
2 7.5 7.5
3 0 0
4 0 0
5 9 9
6 9.5 18.5
7 10 28.5
8 0 0

This is a partial list of a driver log sheet. Column A is hours driven each
day. I'm trying to create a formula that will sum the numbers in column A
backward, or up, to where the previous number is zero and then stop. I was
thinking an IF stmt, but I'm stuck on how to sum upward and then stop when
the cell value is 0.

example: IF(A1=0,"0",sum upward until Ax=0). I don't know what to do for
"sum upward until Ax=0" or if its even possible.

Thanks,
Stefanie