=IF(SUMIF($X$5:$X$19,D5,$Y$5:$Y$19)=0,"",IF(OR(D5=$AP$5,D5=$AP$6,D5=$AP$7,D5=$AP$8,D5=$AP$9,D5=$AP$10,D5=$AP$11),SUMIF($X$5:$X$19,D5,$AB$5:$AB$19),IF(OR(D5=$AP$12,D5=$AP$13,D5=$AP$14,D5=$AP$15,D5=$AP$16,D5=$AP$17,D5=$AP$18,D5=$AP$19),SUMIF($X$5:$X$19
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/10 19:08:49
![=IF(SUMIF($X$5:$X$19,D5,$Y$5:$Y$19)=0,](/uploads/image/z/13754722-58-2.jpg?t=%3DIF%28SUMIF%28%24X%245%3A%24X%2419%2CD5%2C%24Y%245%3A%24Y%2419%29%3D0%2C%22%22%2CIF%28OR%28D5%3D%24AP%245%2CD5%3D%24AP%246%2CD5%3D%24AP%247%2CD5%3D%24AP%248%2CD5%3D%24AP%249%2CD5%3D%24AP%2410%2CD5%3D%24AP%2411%29%2CSUMIF%28%24X%245%3A%24X%2419%2CD5%2C%24AB%245%3A%24AB%2419%29%2CIF%28OR%28D5%3D%24AP%2412%2CD5%3D%24AP%2413%2CD5%3D%24AP%2414%2CD5%3D%24AP%2415%2CD5%3D%24AP%2416%2CD5%3D%24AP%2417%2CD5%3D%24AP%2418%2CD5%3D%24AP%2419%29%2CSUMIF%28%24X%245%3A%24X%2419)
=IF(SUMIF($X$5:$X$19,D5,$Y$5:$Y$19)=0,"",IF(OR(D5=$AP$5,D5=$AP$6,D5=$AP$7,D5=$AP$8,D5=$AP$9,D5=$AP$10,D5=$AP$11),SUMIF($X$5:$X$19,D5,$AB$5:$AB$19),IF(OR(D5=$AP$12,D5=$AP$13,D5=$AP$14,D5=$AP$15,D5=$AP$16,D5=$AP$17,D5=$AP$18,D5=$AP$19),SUMIF($X$5:$X$19
=IF(SUMIF($X$5:$X$19,D5,$Y$5:$Y$19)=0,"",IF(OR(D5=$AP$5,D5=$AP$6,D5=$AP$7,D5=$AP$8,D5=$AP$9,D5=$AP$10,D5=$AP$11),SUMIF($X$5:$X$19,D5,$AB$5:$AB$19),IF(OR(D5=$AP$12,D5=$AP$13,D5=$AP$14,D5=$AP$15,D5=$AP$16,D5=$AP$17,D5=$AP$18,D5=$AP$19),SUMIF($X$5:$X$19,D5,$AK$5:$AK$19)))),谁能帮我解释下这个公式函数什么意思?
=IF(SUMIF($X$5:$X$19,D5,$Y$5:$Y$19)=0,"",IF(OR(D5=$AP$5,D5=$AP$6,D5=$AP$7,D5=$AP$8,D5=$AP$9,D5=$AP$10,D5=$AP$11),SUMIF($X$5:$X$19,D5,$AB$5:$AB$19),IF(OR(D5=$AP$12,D5=$AP$13,D5=$AP$14,D5=$AP$15,D5=$AP$16,D5=$AP$17,D5=$AP$18,D5=$AP$19),SUMIF($X$5:$X$19
(1)SUMIF的三个参数可以理解为:条件区域,条件,数据所在区域既然是区域,就应该用区域引用,这里'1'¥c1:¥c5和'1'¥d1:¥d5都不要加引用,这样就成了文本如果是用文本描述的引用,应该用INDIRECT调用(2)使用具体数值的时候,"=114"也可以简化成114,当然"=114"也没问题.如果是>=114就应该写成">=114",文本条件也还是要加引号.(3)'1'表示对名称为“1”的工作表引用,当工作表名含有数字以及特殊符号的时候要加上单引号.这个可以不用输入,通过鼠标指向目标区域就会自动添加.公式改为:=SUMIF('1'?ぃ茫保海ぃ茫担保保矗Γ#常梗唬保Γ#常梗唬ぃ模保海ぃ模担