excel表格里面统计某个数据的数量 并且这个数据大多部分以多少乘以多少...答:用VBA自定义一个函数。Function SumAA(rng As Range, str As String) Dim rg As Range, st As String, ar() Dim i%, j%, k%, l%, N% For Each rg In rng st = rg.Value l = Len(str) If st <> "" Then i = IIf(InStr(st, str) = 0, 0, InStr...