Try

=IF(C4="G","",SUMPRODUCT((C$4:C$31<>"G")+0,(AH$4:AH$31<AH4)+(AH$4:AH$31=AH4)/2)+0.5)