EXCEL中使用SUMPRODUCT函数时遇到问题,请老师们给予指点---求工作表中销售员为张三,且销售数量>=5的记录个数,其中E列为销售员,C列为销售数量,我输入的公式是=SUMPRODUCT((E3:E14="张三"),(C3:C14>=5)),
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/20 16:43:35
![EXCEL中使用SUMPRODUCT函数时遇到问题,请老师们给予指点---求工作表中销售员为张三,且销售数量>=5的记录个数,其中E列为销售员,C列为销售数量,我输入的公式是=SUMPRODUCT((E3:E14=](/uploads/image/z/12081785-41-5.jpg?t=EXCEL%E4%B8%AD%E4%BD%BF%E7%94%A8SUMPRODUCT%E5%87%BD%E6%95%B0%E6%97%B6%E9%81%87%E5%88%B0%E9%97%AE%E9%A2%98%2C%E8%AF%B7%E8%80%81%E5%B8%88%E4%BB%AC%E7%BB%99%E4%BA%88%E6%8C%87%E7%82%B9---%E6%B1%82%E5%B7%A5%E4%BD%9C%E8%A1%A8%E4%B8%AD%E9%94%80%E5%94%AE%E5%91%98%E4%B8%BA%E5%BC%A0%E4%B8%89%2C%E4%B8%94%E9%94%80%E5%94%AE%E6%95%B0%E9%87%8F%3E%3D5%E7%9A%84%E8%AE%B0%E5%BD%95%E4%B8%AA%E6%95%B0%2C%E5%85%B6%E4%B8%ADE%E5%88%97%E4%B8%BA%E9%94%80%E5%94%AE%E5%91%98%2CC%E5%88%97%E4%B8%BA%E9%94%80%E5%94%AE%E6%95%B0%E9%87%8F%2C%E6%88%91%E8%BE%93%E5%85%A5%E7%9A%84%E5%85%AC%E5%BC%8F%E6%98%AF%3DSUMPRODUCT%28%28E3%3AE14%3D%22%E5%BC%A0%E4%B8%89%22%29%2C%28C3%3AC14%3E%3D5%29%29%2C)
xX[O*TalCviHdEM$}V}(jҐ`lbBc8MCW.9syW<o>s_~kTGjBϿ7{̝}hk5mԜKd\/Q=39^OC6Z:?m
iOپ)נgj;j=zfALd/Jw[L2?OCEti|Ay;덅brxC=>捆Ƣr|}>v'W~9-j1