瀹為獙涓?/p>
鐢?/p>
Excel
杞欢杩涜缁樺浘
涓�銆佸疄楠岀洰鐨?/p>
浣垮鐢熻緝鐔熺粌鍦版帉鎻¤祫鏂欐暣鐞嗗拰缁熻鍥捐〃鐨勭粯鍒舵柟娉曘�?/p>
瑕佹眰浼氫娇鐢?/p>
EXCEL
缁樺埗鐨勫浘
琛ㄣ�佸浘褰紝浠ュ強鍏紡鐨勭紪杈戝拰璁＄畻銆?/p>
浜屻�佸疄楠屽櫒鍏?/p>
璁＄畻鏈?/p>
涓夈�佸疄楠岃姹?/p>
姣忎綅鍚屽涓�鍙拌绠楁満鐙珛瀹屾垚鎿嶄綔锛屽苟缁撳悎涔犻鎸夌収鎿嶄綔鎯呭喌鍐欏嚭銆?/p>
鍥涖�佸疄楠屾搷浣滄楠?/p>
锛堜竴锛夐棿鏂�у彉鏁拌祫鏂欑殑鏁寸悊
渚嬶細
100
涓害绌楃殑姣忕灏忕鏁?/p>
18
15
17
19
16
15
20
18
19
17
17
18
17
16
18
20
19
17
16
18
17
16
17
19
18
18
17
17
17
18
18
15
16
18
18
18
17
20
19
18
17
19
15
17
17
17
16
17
18
18
17
19
19
17
19
17
18
16
18
17
17
19
16
16
17
17
17
15
17
16
18
19
18
18
19
19
20
17
16
19
18
17
18
20
19
16
18
19
17
16
15
16
18
17
18
17
17
16
19
17
锛?/p>
1
锛夋暟鎹緭鍏?/p>
鎵撳紑璁＄畻鏈?/p>
鐐瑰嚮
鈥?/p>
寮�濮?/p>
鈥?nbsp;
閫夋嫨
鈥?/p>
绋嬪簭
鈥?nbsp;
閫夋嫨
鈥淢icrosoft
office鈥?nbsp;
閫夋嫨
鈥渆xcel鈥?/p>
锛岃繘鍏?/p>
excel
鐨勭晫闈紱
锛?/p>
2
锛夊垎缁勶細
鎸夎瀵熷�煎垎缁?/p>
锛?/p>
3
锛夌粺璁℃鏁帮紝骞舵暣鐞嗘垚娆℃暟鍒嗗竷琛紙璋冪敤
countif
鍑芥暟锛?/p>
鍦?/p>
excel
鐣岄潰鐨勫伐鍏锋爮涓偣鍑?/p>
鈥?/p>
鎻掑叆
鈥?nbsp;
閫夋嫨
鈥?/p>
鍑芥暟
鈥?nbsp;
閫夋嫨
鈥?/p>
缁熻
鈥?nbsp;
閫夋嫨
鈥?/p>
countif
鈥?/p>
鐐瑰嚮
鈥?/p>
纭畾
鈥?/p>
銆?/p>
鍦?/p>
countif
瀵硅瘽妗嗕腑锛屽垎甯冮�夊畾
range
锛堟暟鎹尯鍩燂級鍜?/p>
criteria
锛堟寚瀹氬悕绉帮級
锛岀劧鍚庣偣鍑?/p>
鈥?/p>
纭畾
鈥?/p>