涓婃満鎿嶄綔妯℃嫙璇曢锛氱涓�濂?/p>
涓夈�?/p>
Excel 2007
涓婃満棰?/p>
寤虹珛
lx_1.xlsx
宸ヤ綔绨挎枃浠讹紝骞跺湪
Sheet1
宸ヤ綔琛?/p>
A1
寮�濮嬬殑鍗曞厓鏍煎尯鍩熶腑褰曞叆濡備笅鏁版嵁銆?/p>
鎸夌収涓嬪垪瑕佹眰瀹屾垚鐩稿叧鐨勭紪杈戞搷浣滐細
锛?/p>
1
锛夊湪
Sheet1
宸ヤ綔琛ㄤ腑鐨?/p>
A2
锛?/p>
A11
鍗曞厓鏍煎尯鍩熶腑渚濇杈撳叆鍛樺伐鍗″彿鈥?/p>
01001
銆?/p>
01002
銆?/p>
01003
銆?/p>
---
銆?/p>
01010
鈥?/p>
锛屾瀯閫犲叕寮忚绠椻�滃煿璁儴
-
绠＄悊銆佸煿璁儴
-
鎶�鏈�佸煿璁儴
-
鎶�鑳解�濅汉鏁帮紝
骞跺皢璁＄畻缁撴灉渚濇鏀惧湪
C13
銆?/p>
C14
銆?/p>
C15
鍗曞厓鏍间腑銆?/p>
姝ラ锛氬叕寮?/p>
鈫?/p>
鎻掑叆鍑芥暟
鈥?/p>
鎴栭�夋嫨绫诲埆锛堢粺璁★級鈥?/p>
COUNTIF
鈫?/p>
纭畾
鈫?/p>
鍑芥暟鍙傛暟
Range:
閫夊畾鍗曞厓鏍?/p>
锛?/p>
A2
锛氾紵锛?/p>
Criteia:
閫夊畾瑕佽绠楃殑
閿佸畾锛?/p>
A2
锛氾紵锛夋寜
F4
锛?/p>
2
锛夊～鍏?/p>
Sheet1
宸ヤ綔琛ㄤ腑鈥滀功鎶ヨ垂鈥濆垪鐨勬暟鎹�傝亴绉颁负鈥滈珮绾ц甯堚�濈殑鍛樺伐涔︽姤璐?/p>
200
鍏冿紱鑱岀О涓衡�滆甯堚�濈殑鍛樺伐涔︽姤璐逛负
150
鍏冿紱鑱岀О涓衡�滃垵绾ц甯堚�濈殑鍛樺伐涔︽姤璐逛负
100
鍏冿紱璁＄畻姣忎綅鍛樺伐鐨勨�滆ˉ鍔╁悎璁♀�?/p>
锛堣ˉ鍔╁悎璁?/p>
=
璇炬椂璐?/p>
+
涔︽姤璐癸級
銆?/p>
锛?/p>
3
锛?/p>
灏?/p>
Sheet1
宸ヤ綔琛?/p>
A1
锛?/p>
I11
鍗曞厓鏍煎尯鍩熶腑鐨勬暟鎹紝
澶嶅埗鍒?/p>
Sheet2
宸ヤ綔琛?/p>
A1
鍗曞厓鏍?/p>
寮�濮嬬殑鍖哄煙涓紱
鍦?/p>
Sheet2
宸ヤ綔琛ㄤ腑锛?/p>
浣跨敤楂樼骇绛涢�夛紝
鏌ユ壘骞撮緞鍦?/p>
50
宀佸強浠ヤ笅鐨勯珮绾ц甯堢殑
浜哄憳淇℃伅锛堟潯浠跺尯鍩熸斁缃湪
E13
寮�濮嬬殑鍗曞厓鏍煎尯鍩燂級
锛屽苟鎶婄瓫閫夌粨鏋滄斁鍦?/p>
A16
寮�濮嬬殑鍗曞厓鏍?/p>
鍖哄煙涓�?/p>
鏉′欢锛?/p>
姝ラ锛氭暟鎹?/p>
鈫?/p>
楂樼骇
骞撮緞
鑱岀О
<=50
楂樼骇璁插笀