excel宏的多条件求和答:AVERAGEIFS 的参数:要分别求部门二经理人员的人数、总工资、平均工资:部门二经理人员的人数: =COUNTIFS(C2:C24,"部门二",E2:E24,"经理")部门二经理人员的总工资: =SUMIFS(F2:F24,C2:C24,"部门二",E2:E24,"经理")部门二经理人员的平均工资: =AVERAGEIFS(F2:F24,C2:C24,"部门二",E2:E24...
excel同一单元格中有多组文字和数字怎么用宏公式求和答: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, MatchCase:=Fals...