{"id":241,"date":"2026-01-16T21:55:31","date_gmt":"2026-01-16T13:55:31","guid":{"rendered":"http:\/\/www.lijun900303.top\/?p=241"},"modified":"2026-01-16T21:55:31","modified_gmt":"2026-01-16T13:55:31","slug":"%e3%80%90excel%e3%80%91%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/www.lijun900303.top\/?p=241","title":{"rendered":"\u3010excel\u3011\u51fd\u6570"},"content":{"rendered":"\n

Excel\u51fd\u6570\u662f\u9884\u5148\u5b9a\u4e49\u7684\u516c\u5f0f\uff0c\u7528\u4e8e\u5feb\u901f\u5b8c\u6210\u6570\u636e\u8ba1\u7b97\u3001\u5206\u6790\u3001\u903b\u8f91\u5224\u65ad\u7b49\u64cd\u4f5c\uff0c\u6309\u529f\u80fd\u53ef\u5206\u4e3a\u57fa\u7840\u8fd0\u7b97\u3001\u7edf\u8ba1\u5206\u6790\u3001\u903b\u8f91\u5224\u65ad\u3001\u6587\u672c\u5904\u7406\u3001\u67e5\u627e\u5f15\u7528\u7b49\u7c7b\u522b\u3002<\/p>\n\n\n\n

SUM\u51fd\u6570\u53ef\u5feb\u901f\u6c42\u548c\uff0c\u683c\u5f0f\u4e3a\u00a0=SUM(\u6570\u503c\/\u5355\u5143\u683c\u533a\u57df)\u00a0\uff0c\u662f\u57fa\u7840\u8fd0\u7b97\u7684\u5e38\u7528\u5de5\u5177\uff1bVLOOKUP\u51fd\u6570\u5c5e\u4e8e\u67e5\u627e\u5f15\u7528\u7c7b\uff0c\u80fd\u6309\u6307\u5b9a\u6761\u4ef6\u5728\u6570\u636e\u8868\u4e2d\u5339\u914d\u5bf9\u5e94\u6570\u636e\uff0c\u683c\u5f0f\u4e3a\u00a0=VLOOKUP(\u67e5\u627e\u503c, \u67e5\u627e\u533a\u57df, \u8fd4\u56de\u5217\u6570, \u5339\u914d\u7c7b\u578b)\u00a0\u3002IF\u51fd\u6570\u662f\u903b\u8f91\u5224\u65ad\u7684\u6838\u5fc3\uff0c\u683c\u5f0f\u4e3a\u00a0=IF(\u6761\u4ef6, \u6ee1\u8db3\u6761\u4ef6\u8fd4\u56de\u503c, \u4e0d\u6ee1\u8db3\u8fd4\u56de\u503c)\u00a0\uff0c\u53ef\u5b9e\u73b0\u7b80\u5355\u7684\u6761\u4ef6\u7b5b\u9009\u3002\u7edf\u8ba1\u7c7b\u51fd\u6570\u4e2d\uff0cAVERAGE\u7528\u4e8e\u8ba1\u7b97\u5e73\u5747\u503c\uff0cCOUNTIF\u80fd\u6309\u6761\u4ef6\u7edf\u8ba1\u5355\u5143\u683c\u6570\u91cf\uff0c\u6ee1\u8db3\u7cbe\u51c6\u6570\u636e\u7edf\u8ba1\u9700\u6c42\u3002<\/p>\n\n\n\n

\u6587\u672c\u5904\u7406\u7c7b\u51fd\u6570\u5982LEFT\/RIGHT\u53ef\u622a\u53d6\u5b57\u7b26\u4e32\uff0cCONCATENATE\u80fd\u5408\u5e76\u591a\u4e2a\u5355\u5143\u683c\u6587\u672c\uff0c\u9002\u914d\u6587\u672c\u6574\u7406\u573a\u666f\u3002\u4f7f\u7528\u51fd\u6570\u65f6\uff0c\u9700\u6ce8\u610f\u53c2\u6570\u7684\u51c6\u786e\u6027\uff0c\u5355\u5143\u683c\u533a\u57df\u5f15\u7528\u8981\u907f\u514d\u9519\u8bef\uff0c\u90e8\u5206\u51fd\u6570\u533a\u5206\u5927\u5c0f\u5199\uff0c\u5d4c\u5957\u51fd\u6570\u9700\u9075\u5faa\u201c\u5185\u5c42\u4f18\u5148\u201d\u539f\u5219\uff0c\u5408\u7406\u7ec4\u5408\u51fd\u6570\u53ef\u5b9e\u73b0\u590d\u6742\u6570\u636e\u5904\u7406\u4efb\u52a1\uff0c\u5927\u5e45\u63d0\u5347Excel\u7684\u4f7f\u7528\u6548\u7387\u4e0e\u6570\u636e\u5206\u6790\u80fd\u529b\u3002<\/p>\n\n\n\n

<\/p>\n\n\n\n

\u51fd\u6570\u540d\u79f0<\/td>\u51fd\u6570\u683c\u5f0f<\/td>\u6838\u5fc3\u7528\u9014<\/td>\u5e94\u7528\u793a\u4f8b<\/td><\/tr>
SUM<\/td>=SUM(\u6570\u503c1\/\u533a\u57df1, [\u6570\u503c2\/\u533a\u57df2], \u2026)<\/td>\u8ba1\u7b97\u591a\u4e2a\u6570\u503c\u6216\u5355\u5143\u683c\u533a\u57df\u7684\u603b\u548c<\/td>\u8ba1\u7b97A1:A10\u7684\u548c\uff1a=SUM(A1:A10)<\/td><\/tr>
AVERAGE<\/td>=AVERAGE(\u6570\u503c1\/\u533a\u57df1, [\u6570\u503c2\/\u533a\u57df2], \u2026)<\/td>\u8ba1\u7b97\u6570\u503c\u533a\u57df\u7684\u7b97\u672f\u5e73\u5747\u503c<\/td>\u8ba1\u7b97B2:B15\u7684\u5e73\u5747\u503c\uff1a=AVERAGE(B2:B15)<\/td><\/tr>
IF<\/td>=IF(\u6761\u4ef6, \u6ee1\u8db3\u8fd4\u56de\u503c, \u4e0d\u6ee1\u8db3\u8fd4\u56de\u503c)<\/td>\u5355\u6761\u4ef6\u903b\u8f91\u5224\u65ad\u4e0e\u7ed3\u679c\u8fd4\u56de<\/td>\u82e5C1>60\u663e\u793a\u201c\u53ca\u683c\u201d\uff0c\u5426\u5219\u201c\u4e0d\u53ca\u683c\u201d\uff1a=IF(C1>60,”\u53ca\u683c”,”\u4e0d\u53ca\u683c”)<\/td><\/tr>
COUNTIF<\/td>=COUNTIF(\u7edf\u8ba1\u533a\u57df, \u6761\u4ef6)<\/td>\u6309\u5355\u4e00\u6761\u4ef6\u7edf\u8ba1\u5355\u5143\u683c\u6570\u91cf<\/td>\u7edf\u8ba1D2:D20\u4e2d\u5927\u4e8e80\u7684\u5355\u5143\u683c\u6570\uff1a=COUNTIF(D2:D20,”>80″)<\/td><\/tr>
VLOOKUP<\/td>=VLOOKUP(\u67e5\u627e\u503c, \u67e5\u627e\u533a\u57df, \u8fd4\u56de\u5217\u6570, [\u5339\u914d\u7c7b\u578b])<\/td>\u6309\u5217\u67e5\u627e\u5e76\u8fd4\u56de\u5bf9\u5e94\u6570\u636e<\/td>\u5728A2:E10\u4e2d\u67e5\u627eA1\u7684\u503c\uff0c\u8fd4\u56de\u7b2c3\u5217\u6570\u636e\uff1a=VLOOKUP(A1,A2:E10,3,0)<\/td><\/tr>
LEFT<\/td>=LEFT(\u6587\u672c, [\u622a\u53d6\u957f\u5ea6])<\/td>\u4ece\u6587\u672c\u5de6\u4fa7\u5f00\u59cb\u622a\u53d6\u6307\u5b9a\u5b57\u7b26\u6570

<\/td>		\u622a\u53d6F1\u524d3\u4e2a\u5b57\u7b26\uff1a=LEFT(F1,3)<\/td><\/tr>
CONCATENATE<\/td>=CONCATENATE(\u6587\u672c1, \u6587\u672c2, \u2026<\/td>\u5408\u5e76\u591a\u4e2a\u6587\u672c\u6216\u5355\u5143\u683c\u5185\u5bb9<\/td>\u5408\u5e76G1\u548cH1\u5185\u5bb9\uff1a=CONCATENATE(G1,H1)<\/td><\/tr><\/tbody><\/table><\/div><\/figure>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Excel\u51fd\u6570\u662f\u9884\u5148\u5b9a\u4e49\u7684\u516c\u5f0f\uff0c\u7528\u4e8e\u5feb\u901f\u5b8c\u6210\u6570\u636e\u8ba1\u7b97\u3001\u5206\u6790\u3001\u903b\u8f91\u5224\u65ad\u7b49\u64cd\u4f5c\uff0c\u6309\u529f\u80fd\u53ef\u5206\u4e3a\u57fa\u7840\u8fd0\u7b97\u3001\u7edf\u8ba1\u5206\u6790\u3001\u903b\u8f91\u5224\u65ad\u3001\u6587\u672c\u5904\u7406\u3001\u67e5\u627e\u5f15\u7528\u7b49\u7c7b\u522b\u3002 SUM\u51fd\u6570\u53ef\u5feb\u901f\u6c42\u548c\uff0c\u683c\u5f0f\u4e3a\u00a0=SUM(\u6570\u503c\/\u5355\u5143\u683c\u533a\u57df)\u00a0\uff0c\u662f\u57fa\u7840\u8fd0\u7b97\u7684\u5e38\u7528\u5de5\u5177\uff1bVLOOKUP\u51fd\u6570\u5c5e\u4e8e\u67e5\u627e\u5f15\u7528\u7c7b\uff0c\u80fd\u6309\u6307\u5b9a\u6761\u4ef6\u5728\u6570\u636e\u8868\u4e2d\u5339\u914d\u5bf9\u5e94\u6570\u636e\uff0c\u683c\u5f0f\u4e3a\u00a0=VLOOKUP(\u67e5\u627e\u503c, \u67e5\u627e\u533a\u57df, \u8fd4\u56de\u5217\u6570, \u5339\u914d\u7c7b\u578b)\u00a0\u3002IF\u51fd\u6570\u662f\u903b\u8f91\u5224\u65ad\u7684\u6838\u5fc3\uff0c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-241","post","type-post","status-publish","format-standard","hentry","category-project-blog"],"_links":{"self":[{"href":"https:\/\/www.lijun900303.top\/index.php?rest_route=\/wp\/v2\/posts\/241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lijun900303.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lijun900303.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lijun900303.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lijun900303.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=241"}],"version-history":[{"count":2,"href":"https:\/\/www.lijun900303.top\/index.php?rest_route=\/wp\/v2\/posts\/241\/revisions"}],"predecessor-version":[{"id":243,"href":"https:\/\/www.lijun900303.top\/index.php?rest_route=\/wp\/v2\/posts\/241\/revisions\/243"}],"wp:attachment":[{"href":"https:\/\/www.lijun900303.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lijun900303.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lijun900303.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}