Hi
i need the formula to change it's counting range when condition on column A is meet
condition is: when on column A is 1 the counting range start from that "1"
A
1 =IF($B7=C$5,COUNTIF($B$7:$B7,$B7),"0")
2 =IF($B8=C$5,COUNTIF($B$7:$B8,$B8),"0")
3 =IF($B9=C$5,COUNTIF($B$7:$B9,$B9),"0")
1 =if($B10=C$5,COUNTIF($B$10:$B10,$B10),"0") range changed
2 =if($B11=C$5,COUNTIF($B$10:$B11,$B11),"0")
3 =if($B12=C$5,COUNTIF($B$10:$B12,$B12),"0")
4 =if($B13=C$5,COUNTIF($B$10:$B13,$B13),"0")
1 =if($B14=C$5,COUNTIF($B$14:$B14,$B14),"0") range changed
Bookmarks