- ·上一篇:excel表格怎么画船的形状
- ·下一篇:怎么用excel表格算皮尔逊系数
excel表格销售额递增怎么做
2024-12-20 14:29:13
1.如何在EXCEL中实现这种递增
=SUMIF(出库明细表!$D$2:$D$500,10000+ROW(1:1),出库明细表!$J$2:$J$500)
我这个公式向下拉产生的结果是这样的
=SUMIF(出库明细表!$D$2:$D$500,10001,出库明细表!$J$2:$J$500)
=SUMIF(出库明细表!$D$2:$D$500,10002,出库明细表!$J$2:$J$500)
=SUMIF(出库明细表!$D$2:$D$500,10003,出库明细表!$J$2:$J$500)
=SUMIF(出库明细表!$D$2:$D$500,10004,出库明细表!$J$2:$J$500)
=SUMIF(出库明细表!$D$2:$D$500,10005,出库明细表!$J$2:$J$500)
=SUMIF(出库明细表!$D$2:$D$500,10006,出库明细表!$J$2:$J$500)
.
.
.
.
.
.
=SUMIF(出库明细表!$D$2:$D$500,10000+n,出库明细表!$J$2:$J$500)
这难道不是你想要的吗????
