excel的sumif函数里,怎么自动填充隔行的列号?想自动填充SUMIF('01'!$B$2:$B$30,D1,'01'!$E$2:$E$30) SUMIF('01'!$G$2:$G30,D2,'01'!$J$2:$J$30)SUMIF('01'!$J$2:$J$30,D3,'01'!$O$2:$O$30)题目敲错了,是向下拉时,能自动填充隔列
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/03 00:11:21
![excel的sumif函数里,怎么自动填充隔行的列号?想自动填充SUMIF('01'!$B$2:$B$30,D1,'01'!$E$2:$E$30) SUMIF('01'!$G$2:$G30,D2,'01'!$J$2:$J$30)SUMIF('01'!$J$2:$J$30,D3,'01'!$O$2:$O$30)题目敲错了,是向下拉时,能自动填充隔列](/uploads/image/z/11453886-54-6.jpg?t=excel%E7%9A%84sumif%E5%87%BD%E6%95%B0%E9%87%8C%2C%E6%80%8E%E4%B9%88%E8%87%AA%E5%8A%A8%E5%A1%AB%E5%85%85%E9%9A%94%E8%A1%8C%E7%9A%84%E5%88%97%E5%8F%B7%3F%E6%83%B3%E8%87%AA%E5%8A%A8%E5%A1%AB%E5%85%85SUMIF%28%2701%27%21%24B%242%3A%24B%2430%2CD1%2C%2701%27%21%24E%242%3A%24E%2430%29+SUMIF%28%2701%27%21%24G%242%3A%24G30%2CD2%2C%2701%27%21%24J%242%3A%24J%2430%29SUMIF%28%2701%27%21%24J%242%3A%24J%2430%2CD3%2C%2701%27%21%24O%242%3A%24O%2430%29%E9%A2%98%E7%9B%AE%E6%95%B2%E9%94%99%E4%BA%86%2C%E6%98%AF%E5%90%91%E4%B8%8B%E6%8B%89%E6%97%B6%2C%E8%83%BD%E8%87%AA%E5%8A%A8%E5%A1%AB%E5%85%85%E9%9A%94%E5%88%97)
excel的sumif函数里,怎么自动填充隔行的列号?想自动填充SUMIF('01'!$B$2:$B$30,D1,'01'!$E$2:$E$30) SUMIF('01'!$G$2:$G30,D2,'01'!$J$2:$J$30)SUMIF('01'!$J$2:$J$30,D3,'01'!$O$2:$O$30)题目敲错了,是向下拉时,能自动填充隔列
excel的sumif函数里,怎么自动填充隔行的列号?
想自动填充
SUMIF('01'!$B$2:$B$30,D1,'01'!$E$2:$E$30)
SUMIF('01'!$G$2:$G30,D2,'01'!$J$2:$J$30)
SUMIF('01'!$J$2:$J$30,D3,'01'!$O$2:$O$30)
题目敲错了,是向下拉时,能自动填充隔列的列号,规律如B-G-J这样的等距列号.
右下的小黑点这种方式试过不行,去掉B、G、J之前的$也不行.
excel的sumif函数里,怎么自动填充隔行的列号?想自动填充SUMIF('01'!$B$2:$B$30,D1,'01'!$E$2:$E$30) SUMIF('01'!$G$2:$G30,D2,'01'!$J$2:$J$30)SUMIF('01'!$J$2:$J$30,D3,'01'!$O$2:$O$30)题目敲错了,是向下拉时,能自动填充隔列
B到G隔五列,G到J隔三列,没有规律
E到J隔五列,J到O隔五列,有规律公式中的语句 '01'!$E$2:$E$30 可换成 OFFSET('01'!$E$2,0,(ROW()-1)*5,1,1):OFFSET('01'!$E$30,0,(ROW()-1)*5,1,1) 就可以下拉
如果是下拉一行,列就增加5列,公式如下
=SUMIF(OFFSET('01'!$B$2,0,(ROW()-1)*5,1,1):OFFSET('01'!$B$30,0,(ROW()-1)*5,1,1),D1,OFFSET('01'!$E$2,0,(ROW()-1)*5,1,1):OFFSET('01'!$E$30,0,(ROW()-1)*5,1,1))