Can anyone please help me with two different formulas. In my worksheet the value of cell A1 updates automatically and will have a value of either 1 or 0. I need a formula in cell B1 that counts the number of times cell A1 has a value of 1. Also a way to reset it. The second formula I need is for cell C1. This formula needs to accumulate the amount of time cell A1 has a value of 1. Also a way to reset it. I have tried various countif or sumif formulas but cant get it to work.