PDA

View Full Version : Conting consective cells based on criteria



LOSS1574
05-21-2008, 11:25 AM
What formula do I use to count consecutive cells based on criteria, however I need the counter to restart if a different value from the previous one is found?




Any help given is appreciated

Bob Phillips
05-21-2008, 11:49 AM
B1: 1
B2: =IF(A2=A1,B1+1,1)

copy B2 down