合併格人數與平均 (14645)

F2=SUMPRODUCT(N(COUNTIF(OFFSET(A$2,,,ROW($1:$15)),"<>")=ROW(A1)))

G2=SUMPRODUCT((COUNTIF(OFFSET(A$2,,,ROW($1:$15)),"<>")=ROW(A1))*(C$2:C$16))/F2

F2:G5 一公式=SUMPRODUCT((COUNTIF(OFFSET($A$2,,,ROW($1:$15)),"<>")=ROW(A1))*$C$2:$C$16^(B$1=$C$1))/TEXT(E2,"0;;;!1")