瑕佷娇鐢ˋVERAGEIFS鍑芥暟锛屾偍鍙互鎸夌収浠ヤ笅姝ラ鎿嶄綔锛?/p>

1. 鍦‥xcel涓€夋嫨涓€涓崟鍏冩牸浣滀负缁撴灉杈撳嚭浣嶇疆銆?/p>

2. 鍦ㄨ鍗曞厓鏍间腑杈撳叆鍑芥暟鐨勫悕绉?quot;AVERAGEIFS"锛堜笉鍖呮嫭寮曞彿锛夈€?/p>

3. 鍦ㄦ嫭鍙峰唴杈撳叆鍑芥暟鐨勫弬鏁帮紝鎸夌収浠ヤ笅鏍煎紡杩涜杈撳叆锛?/p>

• range1锛氳杩涜骞冲潎鍊艰绠楃殑鑼冨洿銆?/p>

• criteria_range1锛氳繘琛屾潯浠剁瓫閫夌殑绗竴涓寖鍥淬€?/p>

• criteria1锛氫笌绗竴涓潯浠惰寖鍥寸浉瀵瑰簲鐨勬潯浠躲€?/p>

• [criteria_range2]锛氬彲閫夊弬鏁帮紝杩涜鏉′欢绛涢€夌殑绗簩涓寖鍥淬€?/p>

• [criteria2]锛氬彲閫夊弬鏁帮紝涓庣浜屼釜鏉′欢鑼冨洿鐩稿搴旂殑鏉′欢銆?/p>

• 鈥?/p>

鍙互鏍规嵁闇€瑕佹坊鍔犳洿澶氱殑鏉′欢鑼冨洿鍜屾潯浠躲€?/p>

4. 鍦ㄨ緭鍏ュ畬鎵€鏈夊弬鏁板悗锛屾寜涓婨nter閿嵆鍙绠楀嚭骞冲潎鍊笺€?/li>

浠ヤ笅鏄竴涓ず渚嬶細

鍋囪鎮ㄦ湁涓€涓寘鍚鐢熷鍚嶃€佺鐩拰鎴愮哗鐨勬暟鎹〃銆傛偍鎯宠璁＄畻鏌愪釜绉戠洰鐨勫钩鍧囨垚缁╋紝浣嗗彧鑰冭檻鏌愪釜鐗瑰畾瀛︾敓銆?/p>

琛ㄦ牸濡備笅锛?/p>

| 瀛︾敓濮撳悕 | 绉戠洰 | 鎴愮哗 |

|:----------:|:-----:|:-----:|

| 寮犱笁 | 鏁板 | 80 |

| 鏉庡洓 | 鏁板 | 90 |

| 寮犱笁 | 鑻辫 | 85 |

| 鏉庡洓 | 鑻辫 | 95 |

| 寮犱笁 | 鐗╃悊 | 75 |

| 鏉庡洓 | 鐗╃悊 | 85 |

瑕佽绠楀紶涓夊湪鏁板绉戠洰涓婄殑骞冲潎鎴愮哗锛屽彲浠ヤ娇鐢ㄤ互涓嬪叕寮忥細

=AVERAGEIFS(C2:C7, A2:A7, "寮犱笁", B2:B7, "鏁板")

杩欏皢杩斿洖寮犱笁鍦ㄦ暟瀛︾鐩笂鐨勫钩鍧囨垚缁┿€?/p>