SUMIF 行拉公式修改请教=SUM(SUMIF(INDIRECT({"1月","2月","3月"}&"!B:B"),B6,INDIRECT({"1月","2月","3月"}&"!D:D")))公式右拉时,最后的!D:D,如何自动递增!E:E,F:F需要怎么修改?
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/30 09:15:11
![SUMIF 行拉公式修改请教=SUM(SUMIF(INDIRECT({](/uploads/image/z/8839286-62-6.jpg?t=SUMIF+%E8%A1%8C%E6%8B%89%E5%85%AC%E5%BC%8F%E4%BF%AE%E6%94%B9%E8%AF%B7%E6%95%99%3DSUM%28SUMIF%28INDIRECT%28%7B%221%E6%9C%88%22%2C%222%E6%9C%88%22%2C%223%E6%9C%88%22%7D%26%22%21B%3AB%22%29%2CB6%2CINDIRECT%28%7B%221%E6%9C%88%22%2C%222%E6%9C%88%22%2C%223%E6%9C%88%22%7D%26%22%21D%3AD%22%29%29%29%E5%85%AC%E5%BC%8F%E5%8F%B3%E6%8B%89%E6%97%B6%2C%E6%9C%80%E5%90%8E%E7%9A%84%21D%3AD%2C%E5%A6%82%E4%BD%95%E8%87%AA%E5%8A%A8%E9%80%92%E5%A2%9E%21E%3AE%2CF%3AF%E9%9C%80%E8%A6%81%E6%80%8E%E4%B9%88%E4%BF%AE%E6%94%B9%3F)
SUMIF 行拉公式修改请教=SUM(SUMIF(INDIRECT({"1月","2月","3月"}&"!B:B"),B6,INDIRECT({"1月","2月","3月"}&"!D:D")))公式右拉时,最后的!D:D,如何自动递增!E:E,F:F需要怎么修改?
SUMIF 行拉公式修改请教
=SUM(SUMIF(INDIRECT({"1月","2月","3月"}&"!B:B"),B6,INDIRECT({"1月","2月","3月"}&"!D:D")))
公式右拉时,最后的!D:D,如何自动递增!E:E,F:F
需要怎么修改?
SUMIF 行拉公式修改请教=SUM(SUMIF(INDIRECT({"1月","2月","3月"}&"!B:B"),B6,INDIRECT({"1月","2月","3月"}&"!D:D")))公式右拉时,最后的!D:D,如何自动递增!E:E,F:F需要怎么修改?
=SUM(SUMIF(INDIRECT({"1月","2月","3月"}&"!B:B"),B6,INDIRECT({"1月","2月","3月"}&"!"&D:D)))