=SUMPRODUCT(ISNUMBER(FIND("L号",$A$1:$A$10001))*$B$1:$B$10001)
=SUMPRODUCT(ISNUMBER(FIND("XL号",$A$1:$A$10001))*$B$1:$B$10001)
=SUMPRODUCT(ISNUMBER(FIND("3XL号",$A$1:$A$10001))*$B$1:$B$10001)
在要统计的单元格中输入以上公式
304
303
303
303
303
303
303
303
301
301
2024-01-26 14:17
admin