Excel表格快速统计求和的3种方法，自动汇总数据
杩樺湪瀵圭潃Excel琛ㄦ牸閲岀殑鏁板瓧涓€涓竴涓寜璁＄畻鍣紵濂戒笉瀹规槗绠楀畬鍙戠幇鑰佹澘鏀逛簡鏁版嵁鍙堣閲嶆潵锛熶粖澶╁挶浠氨鏉ュ敔鍞犫€斺€旀€庝箞鐢‥xcel鈥?strong>鈥?鍒嗛挓鎼炲畾鏁版嵁缁熻鈥?/strong>鈥嬶紝杩樿兘璁╄〃鏍艰嚜鍔ㄦ洿鏂扮粨鏋滐紒鎴戞暍璇达紝鐪嬪畬杩欑瘒杩為殧澹佽储鍔￠儴鐨勫紶濮愰兘寰楁壘浣犲伔甯垀
涓€銆佸熀纭€浣嗚秴绠＄敤鐨凷UM鍑芥暟
锛堝厛璇翠釜澶у疄璇濓級Excel閲?0%鐨勬眰鍜岄渶姹傦紝鐢ㄢ€?strong>鈥婼UM鍑芥暟鈥?/strong>鈥嬮兘鑳借В鍐筹紒鏂版墜鍒鈥滃嚱鏁扳€濊繖璇嶅悡鍒帮紝鎿嶄綔璧锋潵姣斿井淇″彂绾㈠寘杩樼畝鍗曘€?/p>
涓句釜鏍楀瓙馃尠锛氫綘鏈変竴寮犻攢鍞〃锛岃浠嶣2鍒癇20绠楁€婚攢鍞銆?/p>
- 鍦ㄧ┖鐧藉崟鍏冩牸锛堟瘮濡侭21锛夎緭鍏?鈥?strong>鈥?SUM(鈥?/strong>鈥?/li>
- 榧犳爣鐩存帴妗嗛€塀2鍒癇20锛堜細鐪嬪埌鍏紡鍙樻垚=SUM(B2:B20)锛?/li>
- 鎸夊洖杞﹂敭鈥斺€旀悶瀹氾紒
鈥?strong>鈥嬮噸鐐规潵浜嗏€?/strong>鈥嬶細濡傛灉鑰佹澘绐佺劧璇粹€滄妸B5鐨勬暟鎹敼鎴?88鈥濓紝浣犱細鍙戠幇鎬诲拰鈥?strong>鈥嬭嚜鍔ㄦ洿鏂颁簡鈥?/strong>鈥嬶紒杩欏氨鏄疎xcel姣旇绠楀櫒寮?00鍊嶇殑鍦版柟銆?/p>
浜屻€佹噿浜哄繀瀛︾殑蹇嵎閿ぇ娉?/h3>
锛堥€傚悎鎬ユ€у瓙鐨勬湅鍙嬶級瑕佹槸瑙夊緱杈撳叕寮忓お楹荤儲锛岃浣忚繖涓€?strong>鈥嬮粍閲戠粍鍚堥敭鈥?/strong>鈥嬶細鈥?strong>鈥婣lt + =鈥?/strong>鈥?/p>
鎿嶄綔姝ラ锛?/p>
- 鎶婂厜鏍囨斁鍦ㄨ鏄剧ず缁撴灉鐨勫崟鍏冩牸锛堟瘮濡傛瘡鏈堝悎璁＄殑鏈熬锛?/li>
- 鎸変笅 鈥?strong>鈥婣lt閿笉鏀锯€?/strong>鈥嬶紝鍐嶆寜 鈥?strong>鈥?閿€?/strong>鈥?/li>
- 鐩存帴鎸夊洖杞︹€斺€擡xcel浼氳嚜鍔ㄨ瘑鍒笂鏂规垨宸︿晶鐨勬暟瀛楄寖鍥?/li>
鈥?strong>鈥嬪姣旀祴璇曗€?/strong>鈥嬶細
| 鏂规硶 | 鎿嶄綔鏃堕棿 | 鑷姩鏇存柊 |
|---|---|---|
| 鎵嬪姩璁＄畻鍣?/td> | 3鍒嗛挓 | 鉂?/td> |
| SUM鍑芥暟 | 30绉?/td> | 鉁?/td> |
| Alt+=蹇嵎閿?/td> | 2绉?/td> | 鉁?/td> |
锛堣鍙ユ帍蹇冪獫瀛愮殑璇濓級杩欐嫑鐗瑰埆閫傚悎澶勭悊闅斾笁宸簲灏辫鏀规暟鎹殑鍛ㄦ姤鏈堟姤锛岀敤杩囩殑浜洪兘璇粹€滅湡棣欌€濓紒
涓夈€侀珮闃剁帺瀹剁殑鍔ㄦ€佺粺璁℃湳
锛堣繘闃舵妧宸ч璀︼級濡傛灉浣犻渶瑕佺粺璁＄殑鏁版嵁浼氫笉鏂鍔狅紝姣斿姣忓ぉ閮借褰曟柊璁㈠崟锛岃瘯璇曡繖鎷涒€?strong>鈥嬭秴绾ц〃鏍尖€?/strong>鈥嬪姛鑳斤細
- 閫変腑鏁版嵁鍖哄煙锛屾寜 鈥?strong>鈥婥trl+T鈥?/strong>鈥?鍒涘缓鏅鸿兘琛ㄦ牸
- 鍦ㄢ€滆璁♀€濋€夐」鍗″嬀閫夆€?strong>鈥嬫眹鎬昏鈥?/strong>鈥?/li>
- 鐐瑰嚮姹囨€昏鐨勪笅鎷夌澶撮€夆€滄眰鍜屸€?/li>
鈥?strong>鈥嬩翰韬俯鍧戠粡楠屸€?/strong>鈥嬶細浠ュ墠鐢ㄦ櫘閫氬尯鍩熺粺璁★紝鏂板鏁版嵁鎬昏閲嶆柊鎷夊叕寮忋€傜敤浜嗚繖鏂规硶鍚庯紝鍝€曟暟鎹鍔犲埌1000琛岋紝姹囨€荤粨鏋滀篃浼氣€?strong>鈥嬭嚜鍔ㄨ窡鐫€鍙樷€?/strong>鈥嬶紝鍐嶄篃涓嶇敤鎷呭績婕忕粺璁′簡锛?/p>
鍥涖€侀伩鍧戞寚鍗楋細3涓父瑙佺炕杞︾幇鍦?/h3>
锛堣娉暀璁璀︼級鍒氬紑濮嬬敤杩欎簺鏂规硶鏃讹紝鎴戜篃缈昏繃杞︼細
- 鈥?strong>鈥嬫暟瀛楀彉鏂囨湰鈥?/strong>鈥嬶細鍗曞厓鏍煎乏涓婅鏈夌豢鑹蹭笁瑙掞紵鍙抽敭閫夆€滆浆鎹负鏁板瓧鈥?/li>
- 鈥?strong>鈥嬮殣钘忚娌＄粺璁♀€?/strong>鈥嬶細鐢?鈥?strong>鈥婼UBTOTAL鍑芥暟鈥?/strong>鈥?浠ｆ浛SUM锛屽嬀閫夊拷鐣ラ殣钘忚
- 鈥?strong>鈥嬪悎璁′綅缃笉瀵光€?/strong>鈥嬶細蹇嵎閿粯璁ゅ悜涓?鍚戝乏姹傚拰锛屾墜鍔ㄨ皟鏁磋寖鍥存洿淇濋櫓
涓汉瑙傜偣鏃堕棿
鐢ㄤ簡鍗佸勾Excel锛屾渶娣辩殑浣撲細鏄細鈥?strong>鈥嬩細骞叉椿涓嶅浼氬伔鎳掆€?/strong>鈥嬨€傛妸閲嶅鍔冲姩浜ょ粰鍏紡鍜屽揩鎹烽敭锛岀渷涓嬬殑鏃堕棿鍠濇澂濂惰尪涓嶉鍚楋紵鍒氬紑濮嬪杩欎簺鎶€宸у彲鑳戒細鎵嬪繖鑴氫贡锛屼絾鐩镐俊鎴戯紝缁冧笂涓夋灏辫兘姣旈儴闂ㄩ噷80%鐨勪汉鏁堢巼楂樷€斺€旀瘯绔熷ぇ澶氭暟浜鸿繕鍦ㄧ敤鐫€鈥滈€変腑鍗曞厓鏍肩湅鐘舵€佹爮鈥濊繖绉嶅師濮嬫柟娉曞憿锛?/p>
锛堟渶鍚庡敔鍙ㄤ竴鍙ワ級涓嬫纰板埌瑕佺粺璁＄殑鏁版嵁锛屽埆鐘硅鲍锛佹妸杩欑瘒鏂囩珷缈诲嚭鏉ョ収鐫€鍋氾紝淇濆噯浣犱粠鈥滃姞鐝嫍鈥濆彉韬€滄晥鐜囩帇鈥濓紒