Hi there,

I am trying to add 7 columns. But if one of those columns is zero, I need it to reset and start over.

Can anyone help me with this? I am calculating hours for for our drivers and the rule is that they cannot drive more than 70 hours in 7 days. If they take a day off, then they can start over. So if I enter zero, I need the total to reset and start over. Does this make sense?

Thank you so much for any help.