比如说你可以用最简单的筛选,或者数据透视表,或者用函数:比如sumif(区域“选择商品名一阵列”,条件“需要统计的商品名”,求和列“销售数量列”)订单也是一样的
For example, you can use the simplest filter, or pivot table, or use functions: such as sumif (area "select product name array", condition "product name to be counted", sum column "sales quantity column") The order is the same