把字符串最后面的）去掉，直接在前面加个=号就可以了噻，excel运算时会分优先级自动计算的。=20*20%+30*10%+70*20%+80*10%结果=29
设数据在A列方法一：=sum(countif(A1:A50,{">10",">=20"})*{1,-1})方法二：=countif(A1:A50,">10")-countif(A1:A50,">=20")
