Add +1 To A2 If A1=1 HOW TO

Aug 28, 2009

I simply want to record the number of occurances, without date or time.

if cell a1 = 1 I want it to add +1 to cell a2.

The cell a1 will only be a 0 or a 1, every time cell a1 changes from a 0 to a 1 I want it to add +1 to cell a2. so if a2 has 0, and a1 changes from a 0 to a 1, it will add +1 to a2. a2 now =1. the next time a1 changes from a 0 to a 1, it will add +1 again to a2, a2 now =2.....and so on.

ADVERTISEMENT


ADVERTISEMENT