=IFERROR(IF(AH$2=0,,COUNTIFS(INDEX($C5:$AG5,AG$2+1):INDEX($C5:$AG5,AH$2),"Y")/SUM(COUNTIFS(INDEX($C5:$AG5,AG$2+1):INDEX($C5:$AG5,AH$2),{"y","n"}))),)
and date of the month in AF1
=IFERROR(IF(AH$2=0,,COUNTIFS(INDEX($C5:$AG5,AG$2+1):INDEX($C5:$AG5,AH$2),"Y")/SUM(COUNTIFS(INDEX($C5:$AG5,AG$2+1):INDEX($C5:$AG5,AH$2),{"y","n"}))),)
and date of the month in AF1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks