Excel如何按指定条件求平均值2

[[{"txt": "Excel\u5c0f\u6280\u5de7\uff0c\u5982\u4f55\u6309\u6307\u5b9a\u6761\u4ef6\u6c42\u5e73\u5747\u503c2"}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "WPS"}, {"txt": "Excel"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u600e\u4e48\u5feb\u901f\u8ba1\u7b97\u51fa\u8868\u683c\u4e2d\u6bcf\u4e2a\u73ed\u7ea7\u7684\u5e73\u5747\u5206\u6570\uff0c"}, {"img": ["https://exp-picture.cdn.bcebos.com/256eb672941fbee41ba6f0edc1237971ff1de7d2.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9996\u5148\u9009\u4e2d\u6570\u636e\u533a\u57df\uff0c\u5728\u63d2\u5165\u83dc\u5355\u680f\u4e0b\u70b9\u51fb\u6570\u636e\u900f\u89c6\u8868\uff0c"}, {"img": ["https://exp-picture.cdn.bcebos.com/a9338a1fbee434dac0224a90f271fe1d97d8e4d2.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u5f39\u51fa\u7684\u7a97\u53e3\u4e2d\u70b9\u51fb\u786e\u5b9a\uff0c"}, {"img": ["https://exp-picture.cdn.bcebos.com/955ea0e434daf05e7b5f79c2751d96d81919e5d2.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5c06\u73ed\u7ea7\u62d6\u5165\u884c\uff0c\u5206\u6570\u62d6\u5165\u503c\uff0c"}, {"img": ["https://exp-picture.cdn.bcebos.com/4b626771fe1d96d82d6561932ccd0c6efaf2e1d2.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\u70b9\u51fb\u5206\u6570\u4e0b\u62c9\u83dc\u5355\uff0c\u9009\u62e9\u503c\u5b57\u6bb5\u8bbe\u7f6e\uff0c"}, {"img": ["https://exp-picture.cdn.bcebos.com/359bee5e4a237971cd61966b93196120a6cde3d2.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u503c\u6c47\u603b\u65b9\u5f0f\u4e2d\u9009\u62e9\u5e73\u5747\u503c\uff0c"}, {"img": ["https://exp-picture.cdn.bcebos.com/f11f54237971fe1da2a418aaea20a7cd0d6ee0d2.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\u70b9\u51fb\u6570\u5b57\u683c\u5f0f-\u6570\u503c-\u52fe\u9009\u4f7f\u7528\u5343\u4f4d\u5206\u9694\u7b26-\u786e\u5b9a\uff0c"}, {"img": ["https://exp-picture.cdn.bcebos.com/7830e01d96d81819575ca77e876efbf203b3ded2.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8fd9\u6837\u6bcf\u4e2a\u73ed\u7684\u5e73\u5747\u5206\u6570\u90fd\u8ba1\u7b97\u51fa\u6765\u5566~"}, {"img": ["https://exp-picture.cdn.bcebos.com/31097f43d7d44831c195f614d40f822b75ee51d1.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}]]