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