SUM(SUMIF(A:A,{"668#","202#"},B:B))想问下sumif就可以求和了为什么前面还要加个sum,如果只用sumif得不到我要的结果,但加个sum就可以了,但是我不明白为什么要这么写,还前各位大虾不吝赐教了
来源:学生作业帮助网 编辑:作业帮 时间:2024/09/06 13:46:21
![SUM(SUMIF(A:A,{](/uploads/image/z/6841498-58-8.jpg?t=SUM%28SUMIF%28A%3AA%2C%7B%22668%23%22%2C%22202%23%22%7D%2CB%3AB%29%29%E6%83%B3%E9%97%AE%E4%B8%8Bsumif%E5%B0%B1%E5%8F%AF%E4%BB%A5%E6%B1%82%E5%92%8C%E4%BA%86%E4%B8%BA%E4%BB%80%E4%B9%88%E5%89%8D%E9%9D%A2%E8%BF%98%E8%A6%81%E5%8A%A0%E4%B8%AAsum%2C%E5%A6%82%E6%9E%9C%E5%8F%AA%E7%94%A8sumif%E5%BE%97%E4%B8%8D%E5%88%B0%E6%88%91%E8%A6%81%E7%9A%84%E7%BB%93%E6%9E%9C%2C%E4%BD%86%E5%8A%A0%E4%B8%AAsum%E5%B0%B1%E5%8F%AF%E4%BB%A5%E4%BA%86%2C%E4%BD%86%E6%98%AF%E6%88%91%E4%B8%8D%E6%98%8E%E7%99%BD%E4%B8%BA%E4%BB%80%E4%B9%88%E8%A6%81%E8%BF%99%E4%B9%88%E5%86%99%2C%E8%BF%98%E5%89%8D%E5%90%84%E4%BD%8D%E5%A4%A7%E8%99%BE%E4%B8%8D%E5%90%9D%E8%B5%90%E6%95%99%E4%BA%86)
xJ@%ݴ0H v!p%>.JAk
'6D-E
i^I!=;kE:+ZJe 1X.H^Jdvhloh!|ěKO!8_̴Dv?s) ۃ=su7q&VPe9 C'b'̙dD#4e@[&wIܓmeYSg|t