excel同一单元格中有多组文字和数字怎么用宏公式求和答:Sub 计算()Columns("A:A").Select Selection.Replace What:="米", Replacement:="", LookAt:=xlPart, _SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ReplaceFormat:=False Selection.Replace What:="根", Replacement:="", LookAt:=xlPart, _SearchOrder:=xlByRows, Matc...
excel宏的多条件求和答:部门二经理人员的总工资: =SUMIFS(F2:F24,C2:C24,"部门二",E2:E24,"经理")部门二经理人员的平均工资: =AVERAGEIFS(F2:F24,C2:C24,"部门二",E2:E24,"经理")如果数据源25行以后就没有内容,上面这三个函数还可以引用整列:部门二经理人员的人数: =COUNTIFS(C:C,"部门二",E:E,"经理")...