Hi

I am trying to sum a set of data to a certain value and then want to return
to zero and start the sum calculation again.

I want to use some sort of a formula like:

if(sum(a1:z1)=800,1 (and start back at zero???),"")

I don't know how to get excel to return back to zero once the sum of the
cells has reached 800 or higher.

Any suggestions???
--
cliff