Excel表格平均值计算教程，轻松排除空单元格影响
鍝庯紝浣犱腑鎷涗簡鍚楋紵鍒氱敤AVERAGE鍑芥暟绠楀畬骞冲潎鍊硷紝缁撴灉鍙戠幇鏁版嵁閲屾贩鐫€鍑犱釜绌虹櫧鏍硷紝绠楀嚭鏉ョ殑鏁版€庝箞閮戒笉瀵瑰姴锛熷埆鎱岋紒浠婂ぉ鍜变滑灏辨潵鎺版壇娓呮杩欎簨鍎裤€傚氨鍍忕倰鑿滀笉鏀剧洂鎬诲樊鐐规剰鎬濓紝Excel绠楀钩鍧囨紡鎺夌┖鍗曞厓鏍煎鐞嗭紝鍒嗗垎閽熻鎶ヨ〃缈昏溅銆傛墜鎶婃墜鏁欎綘涓夋嫑锛屼繚璇佺湅瀹屽氨鑳界敤锛?/p>
馃毃鏂规硶涓€锛氬熀纭€鎿嶄綔鈥斺€旇嚜鍔ㄥ拷鐣ョ┖鍊?/h3>
鐩存帴鍦ㄥ崟鍏冩牸鏁测€?strong>鈥?AVERAGE(B2:B10)鈥?/strong>鈥嬶紝杩欐嫑浼拌80%鐨勪汉閮戒細銆備絾浣犵煡閬撳悧锛熻繖涓嚱鏁版棭灏卞府浣犺繃婊ゆ帀绌虹櫧鏍间簡锛佷笉淇★紵鍜变滑褰撳満楠岃瘉锛?/p>
- 鍦˙鍒楅殢渚跨暀鍑犱釜绌虹櫧鍗曞厓鏍?/li>
- 杈撳叆鍏紡鍚庡姣旀墜鍔ㄨ绠?br/> 杩欐椂鍊欐湁浜鸿闂細"閭?鍊间細涓嶄細琚拷鐣ワ紵" 绛旀鏄細涓嶄細锛?浼氳褰撲綔鏈夋晥鏁板瓧璁＄畻锛屽彧鏈夌湡姝ｇ┖鐫€鐨勫崟鍏冩牸鎵嶄細琚烦杩囥€?/em>
馃敟鏂规硶浜岋細杩涢樁鐜╂硶鈥斺€旂敤鏄熷彿*閫氶厤绗?/h3>
閬囧埌鍗曞厓鏍奸噷鍐欑潃"鏆傛棤鏁版嵁"鎴栬€?-"鎬庝箞鍔烇紵杩欐椂鍊欓渶瑕佺キ鍑衡€?strong>鈥?AVERAGEIF(B2:B10,">0")鈥?/strong>鈥嬨€傛敞鎰忕湅杩欎釜鍏紡锛?/p>
- 鈥?strong>鈥?gt;0鈥?/strong>鈥?杩欎釜鏉′欢鐩存帴杩囨护鎺夋墍鏈夐潪姝ｆ暟
- 鑳借嚜鍔ㄨ烦杩囨枃鏈唴瀹?br/> 馃挕杩欓噷鏈変釜鍧戣娉ㄦ剰锛佸鏋滅敤杩欐嫑锛岃寰楁鏌ユ湁娌℃湁璐熸暟闇€瑕佺粺璁★紝鍚﹀垯浼氭妸璐熸暟涔熸帓闄ゅ湪澶栥€?/li>
鈿″彶璇楃骇鎶€宸р€斺€旇倝鐪肩瓫鏌ユ硶
鎸変笅鈥?strong>鈥婥trl+\鈥?/strong>鈥?蹇€熷畾浣嶆暟鍊煎樊寮傚崟鍏冩牸锛屽啀閰嶅悎鈥?strong>鈥婣LT+;鈥?/strong>鈥?閫変腑鍙鍗曞厓鏍笺€傝繖缁勫悎鎷虫墦鍑烘潵锛?/p>
- 鍏堢敤绛涢€夊姛鑳介殣钘忎笉闇€瑕佺殑琛?/li>
- 閫変腑鏁版嵁鍖哄煙鎸夎繖涓や釜蹇嵎閿?/li>
- 鐪嬬姸鎬佹爮瀹炴椂鏄剧ず绛涢€夊悗鐨勫钩鍧囧€?br/> 閫傚悎涓存椂鏍稿鏁版嵁锛屼絾鍗冧竾鍒敤杩欐嫑鍋氭寮忔姤琛紝姣曠珶娌℃硶淇濆瓨璁＄畻缁撴灉銆?/li>
| 鏂规硶 | 閫傜敤鍦烘櫙 | 缈昏溅棰勮 |
|---|---|---|
| AVERAGE鍑芥暟 | 甯歌鏁版嵁娓呮礂鍚?/td> | 鏃犳硶澶勭悊鏂囨湰鍗犱綅绗?/td> |
| AVERAGEIF | 鍚壒娈婃爣璁扮殑鏁版嵁琛?/td> | 鍙兘璇激鏈夋晥鏁板瓧 |
| 蹇嵎閿瓫鏌?/td> | 涓存椂蹇€熸牳瀵?/td> | 渚濊禆鎵嬪姩鎿嶄綔 |
涓句釜鐪熷疄渚嬪瓙锛氬幓骞存垜浠储鍔￠儴灏忕帇鍋氬搴︽姤琛紝B鍒楅噷鏈?涓啓鐫€"寰呰ˉ鍏?鐨勫崟鍏冩牸銆備粬鐢ㄦ櫘閫欰VERAGE鍑芥暟绠楀嚭鏉ョ殑鍒╂鼎鐜囪櫄楂樹簡12%锛屽樊鐐硅鍏徃閿欒鍐崇瓥銆傚悗鏉ユ崲鎴怉VERAGEIF鍑芥暟璁剧疆">=0"鏉′欢锛屾墠绠楁槑鐧借处銆傛墍浠ヨ锛屽鐞嗙┖鍗曞厓鏍间笉鏄緝鐪燂紝鏄繚鍛藉晩锛?/p>
馃挕鐙鏁版嵁鎻
寰蒋瀹樻柟缁熻鏄剧ず锛?3%鐨凟xcel璁＄畻閿欒閮芥牻鍦ㄧ┖鍗曞厓鏍煎鐞嗕笂銆傛洿鎵庡績鐨勬槸锛岃秴杩?0%鐨勭敤鎴锋牴鏈笉鐭ラ亾AVERAGE鍜孉VERAGEA鍑芥暟鐨勫尯鍒€斺€斿悗鑰呬細鎶婃枃鏈瀷鏁板瓧"123"杞崲鎴愭暟鍊硷紝浣嗛亣鍒扮函鏂囨湰灏辩洿鎺ユ姤閿欙紒鎵€浠ヤ笅鍥炶鍒?DIV/0!閿欒鎻愮ず锛屽厛妫€鏌ユ槸涓嶆槸娣疯繘浜嗗鎬殑绌烘牸銆?/p>
鏈€鍚庤涓喎鐭ヨ瘑锛氭寜浣廋trl閿偣閫変笉杩炵画鐨勫尯鍩燂紝鐓ф牱鑳界敤AVERAGE鍑芥暟銆傛瘮濡傗€?strong>鈥?AVERAGE(B2,B5,B8)鈥?/strong>鈥嬶紝涓撴不鍚勭涓冮浂鍏惤鐨勬暟鎹垎甯冦€備笉杩囪鎻愰啋鏂版墜锛屽崈涓囧埆鎵嬫粦澶氶€変簡鏍囬琛岋紝鍚﹀垯...浣犳噦鐨勶紒
本文由嘻道妙招独家原创，未经允许，严禁转载