sum function

Giganews Newsgroups
Subject: sum function
Posted by:  cliff
Date: Fri, 16 Jun 2006


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???