除4余数的个数 空白不計 (12409)

O2:R14=SUMPRODUCT((MOD((0&$D2:$M2),4)=COLUMN()-15)*($D2:$M2<>""))

另解{=COUNT(0/(MOD(IF($D2:$M2<>"",$D2:$M2,""),4)=COLUMN(A1)-1))