- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 June
- sum function

Subject: | sum function |

Posted by: | cliff |

Date: | Fri, 16 Jun 2006 |

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

- RE: sum function posted by CLR on Fri, 16 Jun 2006