Quote Originally Posted by ChemistB View Post
Yes, sorry about that.
Hi Chemist. Thanks for the formula. It is reseting too many times. It is reseting everytime column k is changing. I don't want it to reset every time k changes.

If N is equal to "Change", that means the order has changed so restart the running total every time. But if N is not equal to "Change" then the order is not the same so continue the running total, only reset the count when column s is greater or equal to 60 and if column k has changed.

Order of operation:

First look at column n to look for "Change"
Then look at column s for 60 or greater
Then look at column k for a change

Thanks for you help.