excel琛ㄦ牸濡備綍绠楀钩鍧囨暟
扬州沐宇科技
2023-10-09 14:56:27
鍦‥xcel涓紝鎮ㄥ彲浠ヤ娇鐢ㄤ互涓嬪叕寮忚绠楀钩鍧囨暟锛?/p>
-
骞冲潎鏁帮細浣跨敤"AVERAGE"鍑芥暟璁＄畻涓€缁勬暟鎹殑骞冲潎鍊笺€備緥濡傦紝濡傛灉鎮ㄧ殑鏁版嵁浣嶄簬A1鍒癆10鍗曞厓鏍间腑锛屾偍鍙互浣跨敤浠ヤ笅鍏紡璁＄畻骞冲潎鏁帮細=AVERAGE(A1:A10)銆?/p>
-
鏉′欢骞冲潎鏁帮細浣跨敤"AVERAGEIF"鍑芥暟璁＄畻婊¤冻鐗瑰畾鏉′欢鐨勬暟鎹殑骞冲潎鍊笺€備緥濡傦紝濡傛灉鎮ㄧ殑鏁版嵁浣嶄簬A1鍒癆10鍗曞厓鏍间腑锛屾偍鍙互浣跨敤浠ヤ笅鍏紡璁＄畻澶т簬绛変簬5鐨勬暟鎹殑骞冲潎鏁帮細=AVERAGEIF(A1:A10,鈥?gt;=5鈥?銆?/p>
-
鍔犳潈骞冲潎鏁帮細浣跨敤"SUMPRODUCT"鍑芥暟灏嗘暟鎹笌鏉冮噸鐩镐箻锛屽苟灏嗙粨鏋滅浉鍔狅紝鐒跺悗鍐嶉櫎浠ユ潈閲嶇殑鎬诲拰銆備緥濡傦紝濡傛灉鎮ㄧ殑鏁版嵁浣嶄簬A1鍒癆10鍗曞厓鏍间腑锛屾潈閲嶄綅浜嶣1鍒癇10鍗曞厓鏍间腑锛屾偍鍙互浣跨敤浠ヤ笅鍏紡璁＄畻鍔犳潈骞冲潎鏁帮細=SUMPRODUCT(A1:A10,B1:B10)/SUM(B1:B10)銆?/p>
璇锋牴鎹偍鐨勫叿浣撻渶姹傞€夋嫨閫傚悎鐨勫叕寮忔潵璁＄畻骞冲潎鏁般€?/p>
