多个sumif相加如何简化公式=SUMIF(一月份蓝票!$E$2:$E$51,$B2,一月份蓝票!$F$2:$F$51)

多个sumif相加如何简化公式
=SUMIF(一月份蓝票!$E$2:$E$51,$B2,一月份蓝票!$F$2:$F$51)+SUMIF(二月份蓝票!$E$2:$E$51,$B2,二月份蓝票!$F$2:$F$51)+SUMIF(三月份蓝票!$E$2:$E$51,$B2,三月份蓝票!$F$2:$F$51)+SUMIF(四月份蓝票!$E$2:$E$51,$B2,四月份蓝票!$F$2:$F$51)·······+SUMIF(十二月份蓝票!$E$2:$E$51,$B2,十二月份蓝票!$F$2:$F$51) 求简化别直接说用哪个函数 真心不懂啊
想ii不ii 1年前 已收到1个回答 举报

rogerd 春芽

共回答了13个问题采纳率:92.3% 举报

=SUM(SUMIF(INDIRECT({"一","二","三","四","五","六","七","八","九","十","十一","十二"}&"月份蓝票!E2:E51"),$B2,INDIRECT({"一","二","三","四","五","六","七","八","九","十","十一","十二"}&"月份蓝票!F2:F51")))

1年前

4
可能相似的问题
Copyright © 2024 YULUCN.COM - 雨露学习互助 - 16 q. 0.039 s. - webmaster@yulucn.com