Try
=IF(C4="G","",SUMPRODUCT((C$4:C$31<>"G")+0,(AH$4:AH$31<AH4)+(AH$4:AH$31=AH4)/2)+0.5)
Try
=IF(C4="G","",SUMPRODUCT((C$4:C$31<>"G")+0,(AH$4:AH$31<AH4)+(AH$4:AH$31=AH4)/2)+0.5)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks