=sum(mod(b2:f2,2))&":"&sum(mod(b2:f2-1,2)) ps:数组公式,输入时按ctrl+shift+enter完成. 辅仁药业9 · 多才多E. 9. =+SUM(MOD(B2:F2,2))&":0"&COUNT(B2:F2)-G2.
tieba.baidu.com