SUM Question

[Skeels]

I am conducting an experiment on several valves and when one breaks I have a checkbox which I can turn on and off in order keep track of which ones are running. As of now I have used an IF statement to sum the number of cycles as long as the valve is in operation, but once it breaks I cannot get it to simply stay at the total number of cycles. Once I uncheck the box it just says false. Is there some sort of function I can use to sum until it is unchecked? Can Excel even do this or should I just use some other program?

 

[Somendra Misra]

Hi Skeels,

Welcome to Chandoo.org forum.
See the attached file. Is this what you are looking for? or else upload a sample file.

Regards,

 

[Faseeh]

@Skeels

Can you upload a sample file??