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\