1. 濡备綍鐢‥XCEL杩涜屾暟鎹鍒嗙粍濡备綍鐢╡xcel杩涜屾暟鎹鍒嗙粍鎺掑簭
宸ュ叿𨱒愭枡锛
Excel杞浠
镎崭綔鏂规硶
01
1.鍗曢”寮忔暟鎹鍒嗙粍
濡傛灉鏁版嵁鍙桦姩杈冨皬锛屽垎缁勫彲浠ユ槸鍗曢”寮忕殑锛屽嵆灏嗘疮涓镐ц川镄勬暟鎹鍒嗕负涓缁勚傚备笅闱㈢殑鍒嗙彮𨱍呭喌钥岃█锛屽彲浠ュ垎涓轰竴鐝锛屼簩鐝鍜屼笁鐝銆
锛1锛夊湪宸ヤ綔琛ㄧ┖锏藉勫缓绔嫔垎鐝𨱍呭喌骞跺缓绔嬩汉鏁扮粺璁°
02
锛2锛夐夊畾F2鍗曞厓镙硷纴鍦ㄥ叕寮忕紪杈戞爮涓婅緭鍏ュ叕寮忥细=COUNTIF($B$2:$B$10,E2)锛屾寜Enter阌锛屽嵆鍙璁＄畻鍑烘疮涓鐝镄勪汉鏁般
03
锛3锛夊皢鍏夋爣瀹氢綅鍦‵2鍗曞厓镙肩殑鍙充笅瑙掞纴钖戜笅𨰾栧姩濉鍏呮焺澶嶅埗鍏寮忥纴鍗冲彲璁＄畻鍑哄叾浠栫彮绾х殑浜烘暟銆
04
2. 缁勮窛寮忔暟鎹鍒嗙粍
濡傛灉鏁版嵁鍙桦姩骞呭害澶э纴搴旂敤缁勮窛寮忓垎缁勶纴鍗冲悎骞舵煇浜涙ц川鍗佸垎鐩镐技镄勬暟鎹銆
锛1锛夊湪琛ㄦ牸绌虹槠澶勫皢鏁版嵁鍒嗕负钬<
70钬,钬70-80钬,钬80-90钬,钬90-100钬濊繖锲涚粍鏁版嵁锛屽苟娣诲姞浜烘暟镙囱瘑銆
05
锛2锛夐変腑F2鍗曞厓镙硷纴鍦ㄥ叕寮忕紪杈戞爮涓婅緭鍏ュ叕寮忥细=COUNTIF(C2:C10,\"<
70\")锛屾寜Enter阌鍙寰楀埌鎴愮哗灏忎簬70镄勪汉鏁般
06
锛3锛夐変腑F3鍗曞厓镙硷纴鍦ㄥ叕寮忕紪杈戞爮涓婅緭鍏ュ叕寮忥细=COUNTIFS(C2:C10,\">
70\