hi,

I have a cell that shows 1, every time a random number matching that cell is generated. for example if cell A1 = 1, and a rand function shows 1 in cell B1, then cell C1 will show 1.

I want to keep incrementing C1 every time cell B1 shows 1, if B1 =0 then the value of C1 must remain same as previous value. its like adding a counter and it only add's up by 1 when the value of cell B1 is 1, otherwise it does not count but also does not reset.