I want to add a series of 7 numbers with the result displaying in the second
column. When one of the numbers encounters a 0 to display
0.=IF(A70,A1+A2+A3+A4+A5+A6+A7,0) This gets the desired results but once it
encounters the 0 I want it to recognize this as the starting point for adding
the next series of 7 numbers.
neta