D3:F10{=IFERROR(INDEX(IF(SUM(N(SUBTOTAL(3,OFFSET($B$3,,,ROW($1:$8)))=COUNTIF($B$3:$B3,"<>")))=3,{5,3,2},{6,4,0})/10,TEXT((ROW(A1)-LOOKUP(1,0/($B$3:$B3<>""),ROW($1:1))+1=COLUMN(A1))*COLUMN(A1),"0;;"))*LOOKUP(9^9,$G$3:$G3),"")
O2:Q5=SUMIF($C:$C,$N2,D:D)
留言
張貼留言