{"id":817,"date":"2026-03-07T19:08:54","date_gmt":"2026-03-07T11:08:54","guid":{"rendered":"https:\/\/hychzj.cn\/?p=817"},"modified":"2026-03-07T19:08:56","modified_gmt":"2026-03-07T11:08:56","slug":"%e7%94%b5%e8%84%91%e5%b0%8f%e7%99%bdexcel%e5%8a%9e%e5%85%ac%ef%bc%8c20%e4%b8%aa%e6%a0%b8%e5%bf%83%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/hychzj.cn\/index.php\/2026\/03\/07\/%e7%94%b5%e8%84%91%e5%b0%8f%e7%99%bdexcel%e5%8a%9e%e5%85%ac%ef%bc%8c20%e4%b8%aa%e6%a0%b8%e5%bf%83%e5%87%bd%e6%95%b0\/","title":{"rendered":"\u7535\u8111\u5c0f\u767dExcel\u529e\u516c\uff0c20\u4e2a\u6838\u5fc3\u51fd\u6570"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1800\" src=\"https:\/\/hychzj.cn\/wp-content\/uploads\/2026\/03\/45e5a785158730cbd58fb97bc4215a6c.png\" alt=\"\" class=\"wp-image-818\"\/><\/figure>\n\n\n\n<p>SUM \u6c42\u548c . <\/p>\n\n\n\n<p>AVERAGE \u5e73\u5747\u503c . <\/p>\n\n\n\n<p>MAX \u6700\u5927\u503c . <\/p>\n\n\n\n<p>MIN \u6700\u5c0f\u503c . <\/p>\n\n\n\n<p>COUNT \u8ba1\u6570 . <\/p>\n\n\n\n<p>COUNTA \u975e\u7a7a\u8ba1\u6570 . <\/p>\n\n\n\n<p>IF \u6761\u4ef6\u5224\u65ad . <\/p>\n\n\n\n<p>VLOOKUP \u67e5\u627e . <\/p>\n\n\n\n<p>XLOOKUP \u65b0\u7248\u67e5\u627e . <\/p>\n\n\n\n<p>SUMIF \u6761\u4ef6\u6c42\u548c . <\/p>\n\n\n\n<p>SUMIFS \u591a\u6761\u4ef6\u6c42\u548c . <\/p>\n\n\n\n<p>ROUND \u56db\u820d\u4e94\u5165 . <\/p>\n\n\n\n<p>ROUNDUP \u5411\u4e0a\u53d6\u6574 . <\/p>\n\n\n\n<p>ROUNDDOWN \u5411\u4e0b\u53d6\u6574 . <\/p>\n\n\n\n<p>TRIM \u6e05\u9664\u7a7a\u683c . <\/p>\n\n\n\n<p>LEFT \u6587\u672c\u622a\u53d6 . <\/p>\n\n\n\n<p>CONCAT \u6587\u672c\u5408\u5e76 . <\/p>\n\n\n\n<p>TODAY \u81ea\u52a8\u65e5\u671f . <\/p>\n\n\n\n<p>DATEDIF \u65e5\u671f\u95f4\u9694 . <\/p>\n\n\n\n<p>IFERROR \u9519\u8bef\u5c4f\u853d .<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1800\" src=\"https:\/\/hychzj.cn\/wp-content\/uploads\/2026\/03\/54de7282343319b139c0958c0eeeabef.png\" alt=\"\" class=\"wp-image-819\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1800\" src=\"https:\/\/hychzj.cn\/wp-content\/uploads\/2026\/03\/6609643e7a985e3310726c5cf0708edf.png\" alt=\"\" class=\"wp-image-820\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1800\" src=\"https:\/\/hychzj.cn\/wp-content\/uploads\/2026\/03\/f840b3e164e29111edb2ad21943d2f37.png\" alt=\"\" class=\"wp-image-821\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1800\" src=\"https:\/\/hychzj.cn\/wp-content\/uploads\/2026\/03\/1c3c02ab814623f874cc7747918aa7b5.png\" alt=\"\" class=\"wp-image-822\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1800\" src=\"https:\/\/hychzj.cn\/wp-content\/uploads\/2026\/03\/66c7d4f3e92fbd98b260a1ab3186ef52.png\" alt=\"\" class=\"wp-image-823\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1800\" src=\"https:\/\/hychzj.cn\/wp-content\/uploads\/2026\/03\/e7e15a3d2d79e458e401388a650faef8.png\" alt=\"\" class=\"wp-image-824\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1800\" src=\"https:\/\/hychzj.cn\/wp-content\/uploads\/2026\/03\/029f56ac11e5624549c43d169b089d35.png\" alt=\"\" class=\"wp-image-825\"\/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SUM \u6c42\u548c . AVERAGE \u5e73\u5747\u503c . MAX \u6700\u5927\u503c . MIN \u6700\u5c0f\u503c . COUNT \u8ba1\u6570 . C [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-817","post","type-post","status-publish","format-standard","hentry","category-1"],"_links":{"self":[{"href":"https:\/\/hychzj.cn\/index.php\/wp-json\/wp\/v2\/posts\/817","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hychzj.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hychzj.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hychzj.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hychzj.cn\/index.php\/wp-json\/wp\/v2\/comments?post=817"}],"version-history":[{"count":1,"href":"https:\/\/hychzj.cn\/index.php\/wp-json\/wp\/v2\/posts\/817\/revisions"}],"predecessor-version":[{"id":826,"href":"https:\/\/hychzj.cn\/index.php\/wp-json\/wp\/v2\/posts\/817\/revisions\/826"}],"wp:attachment":[{"href":"https:\/\/hychzj.cn\/index.php\/wp-json\/wp\/v2\/media?parent=817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hychzj.cn\/index.php\/wp-json\/wp\/v2\/categories?post=817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hychzj.cn\/index.php\/wp-json\/wp\/v2\/tags?post=817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}