excel累加求和函数

假设月销售额在A1单元格中，则公式为：
=SUM((A1>{0,1,2,3,4,5,6,7,8,9,10}*10000)*((A1-{0,1,2,3,4,5,6,7,8,9,10}*10000)*0.01))

如果将上式中的{0,1,2,3,4,5,6,7,8,9,10}*10000定义名称为aa，则公式可简化为：
=SUM((A1>aa)*((A1-aa)*0.01))
按ctrl+shift+enter三键结束。

如果数据在A1:A100中,B1中输入
=SUM(IF(A1<10000,0,IF(A1>10000*(ROW(INDIRECT("1:""IENT(A1,10000)))-1),100*ROW(INDIRECT("1:""IENT(A1,10000))))))+MOD(A1,10000)*(QUOTIENT(A1,10000)+1)%
同时按下CTEL+SHIFE+ENTER输入数组公式,再用自动填充柄将公式向下复制就可以了.

=IF(A2<=10000,A*1%,IF(AND(A2>10000,A2<=20000),100+(A2-10000)*2%,IF(AND(A2>20000,A2<=30000),300+(A2-20000)*3%,IF(AND(A2>30000,A2<=40000),600+(A2-20000)*4%,1400+(A2-20000)*5%))))
A2是月销售额

=(1+int(a1/10000))*int(a1/10000)*50+mod(a1,10000)*(int(a1/10000)+1)*0.01