1、例如表格中某一个发货快递或某一产品的个数统计
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/55e736d12f2eb938a94f0cacdb628535e5dd6f49?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、现查询发货快递“德邦”的个数和产品“手机”的个数,在新的单元格中输入“=COUNTIF(B:B,B3)”,然后回车就得到发货快递“德邦”的数据统计。产品统计也按相同的方法。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9c16fdfaaf51f3def4dbcf3a9aeef01f3a297906?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、查询产品“手机”的个数,也是用相同的方法。即在新单元格中输入“=COUNTIF(C:C,C3)”.Countif函数是Excel中对指定区域中符合指定条件的单元格计数的一个函数,"C:C"表格单元格C列,C3表示与C3表格中相同的数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/960a304e251f95cab6bbe4e8c7177f3e67095225?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在数据统计单元中,把鼠标放右下角“+”上,按住鼠标左键向下拉,可以依次得到与相对应单元格数据相同的个数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/242dd42a2834349b006318dbc7ea15ce36d3be02?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)