總和 空白同上非空白值 (11804)

G2{=SUM(RIGHT(SMALL({1,2,3,4,5}*10^8+(B$2:F2>0)*ROW($1:1)*10^6+B$2:F2,ROW($1:$5)*ROW(A1)),6)*1)

另解{=SUM((SUBTOTAL(3,OFFSET(B1,,COLUMN(A:E)-1,-ROW($1:1)))=1)*N(OFFSET(B1,,COLUMN(A:E)-1,-ROW($1:1)))*(B2:F2=""))+SUM(B2:F2)

另解{=SUM(N(OFFSET(B$2,LOG(MMULT(TRANSPOSE(10^ROW($1:1)),1-(B$2:F2="")))-1,{0,1,2,3,4})))

另解{=SUM(N(OFFSET(B2,,{0,1,2,3,4},-ROW($1:1)))*(SUBTOTAL(2,OFFSET(B2,,{0,1,2,3,4},-ROW($1:1)))=1))

另解=LOOKUP(10^10,$B$2:$B2)+LOOKUP(10^10,$C$2:$C2)+LOOKUP(10^10,$D$2:$D2)+LOOKUP(10^10,$E$2:$E2)+LOOKUP(10^10,$F$2:$F2)

另解{=SUM(--RIGHT(LARGE(IF(B$2:F2="",,ROW(B$2:F2)*10^3+B$2:F2)+COLUMN(B$2:F2)*10^6,(ROW($1:$5)-1)*ROW(A1)+1),3))