excel
灞曞紑鍏ㄩ儴
excel鐨勪竴涓緢澶х殑浣滅敤灏辨槸鍙互鐢ㄦ潵姹傚拰锛屽府鍔╃敤鎴锋洿蹇殑杩涜璁＄畻锛屽浜庡垰鎺ヨЕ鐢ㄦ埛鏉ヨ鍙兘骞朵笉鐭ラ亾
excel鍑芥暟姹傚拰鎬庝箞鎿嶄綔锛屽洜姝ょ粰浣犱滑甯︽潵浜嗘眰鍜屾暀绋嬨€�
excel鍑芥暟姹傚拰鎬庝箞鎿嶄綔锛�涓€銆丼UM鍑芥暟姹傚拰锛�鏂规硶锛�鍦ㄧ洰鏍囧崟鍏冩牸涓緭鍏ュ叕寮忥細=SUM(C3:C9)浜屻€佸崟鏉′欢姹傚拰锛歋UMIF鎴朣UMPRODUCT鍑芥暟锛�涓句緥姹傗€滀笂娴封€濇€婚攢閲忋€�鏂规硶锛�杈撳叆鍏紡锛�=SUMIF(E3:E9,"涓婃捣",C3:C9)鎴�=SUMPRODUCT((E3:E9="涓婃捣")*C3:C9)涓夈€佸鏉′欢姹傚拰:SUMIFS鍑芥暟鍜孲UMPRODUCT鍑芥暟涓句緥璁＄畻鈥滀笂娴风敺鈥濋攢鍞憳鎬婚攢閲�鏂规硶锛�杈撳叆鍏紡锛�=SUMIFS(C3:C9,D3:D9,"鐢�",E3:E9,"涓婃捣")鎴�=SUMPRODUCT((D3:D9="鐢�")*(E3:E9="涓婃捣")*C3:C9)
