1、要求根据B列和C列的资料快速求出E列产品的成本费用,要求结果为汇总数,结果在F列列示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/86d6277f9e2f070871f9ae6ae724b899a801f2d8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、点击选中F2单元格,在单元格中输入运算符号=,然后点击【插入函数】按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b03533fa828ba61e5a044c454f34970a314e59f6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、通过上一步骤操作,系统弹出【插入函数】对话框,在【选择函数】中选择[SUMIF]函数,然后点击【确定】按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/64380cd7912397dd0d821c6e5782b2b7d1a287e5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、系统弹出【函数参数】对话框:将光标移动到第一个参数后面的对话框中,在工作表中点击选中B列;将光标移动到第二个参数后面的对话框中,在工作表中点击选中E2单元格,即要汇总的材料名称;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cefc1e178a82b9010e2b47597d8da9773812efd2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、回到工作表中,材料B的成本费用的汇总数已经求出,点击选中该单元格,点击鼠标左键拖动鼠标复制公式到剩余单元格中。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/91ef76c6a7efce1b53da4ca0a151f3deb58f65e3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)