Will there ever be more than 1 zero? What should happen if there is more
than 1 zero?

Assuming there will *always* be 1 zero:

=SUM(A7:INDEX(A1:A7,MATCH(0,A1:A7,0)))

--
Biff
Microsoft Excel MVP


"Curtis" wrote in message
...
If I had column A with numbers; like if A1=15; A2=10; A3=12; A4=5; A5=8;
A6=10; A7=10 when I sum all this together it total to B1=70. Question is
if
A6=0 and rest are the same then b1=10, what I trying to do is if there any
zero then it only add after zero not before. If A5=0 then A6 and A7 adds
to
20, any help on this?