假设数据在A1：G7，均值公式：
=AVERAGEIFS(A1:G7,A1:G7,">=51",A1:G7,"<=51.7")
在公式单元格中输入
=AVERAGE(IF((A1:G7>=51)*(A1:G7<=51.7),A1:G7))
按【组合键】确认！！！
=sumifs(区域,区域,">=51",区域,"<=51.7)/countifs(区域,区域,">=51",区域,"<=51.7)
写好之后 按三个键结束 Ctrl+Shift+Enter
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024