{"id":361,"date":"2012-01-11T15:57:39","date_gmt":"2012-01-11T07:57:39","guid":{"rendered":"http:\/\/cowman-chiang.no-ip.org\/wordpress\/?p=361"},"modified":"2023-10-31T15:51:46","modified_gmt":"2023-10-31T07:51:46","slug":"excel-%e8%b7%b3%e6%a0%bc%e8%a8%88%e7%ae%97","status":"publish","type":"post","link":"https:\/\/cowmanchiang.me\/wp\/?p=361","title":{"rendered":"Excel \u8df3\u683c\u8a08\u7b97"},"content":{"rendered":"<p>\u9019\u662f\u602a\u7378\u5169\u500b\u591a\u79ae\u62dc\u4ee5\u524d\u554f\u7684&#8230;<br \/>\n\u7576\u6642\u5728\u9996\u90fd\u4e0a\u5c31\u6c92\u8fa6\u6cd5\u5e6b\u4ed6\u627e\u4e86<br \/>\n\u525b\u525b\u624d\u60f3\u5230\u6709\u9019\u500b\u554f\u984c&#8230;Orz \u771f\u7684\u8001\u4e86<\/p>\n<p>\u7db2\u8def\u4e0a\u627e\u4e86\u4e00\u4e0b\u76f8\u95dc\u7684\u554f\u984c<br \/>\n\u4f7f\u7528\u4e0b\u5217\u5c31\u53ef\u4ee5\u89e3\u6c7a\u4e86<br \/>\n=SUM(IF(MOD(ROW(A1:A65535),5)=2,A1:B65535))<br \/>\n\u6309\u4e0bALT+SHIFT+ENTER\u8b8a\u6210\u9663\u5217\u904b\u7b97<\/p>\n<p>\u5176\u4e2d\u4e3b\u8981\u662f\u7528MOD 5\u99182\u7684\u5132\u5b58\u683c\u4f86\u8a08\u7b97<br \/>\n\u5f8c\u9762\u7684A1:B65535\u4e3b\u8981\u5c31\u662f\u8981\u8a08\u7b97\u7684\u7bc4\u570d<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9019\u662f\u602a\u7378\u5169\u500b\u591a\u79ae\u62dc\u4ee5\u524d\u554f\u7684&#8230; \u7576\u6642\u5728\u9996\u90fd\u4e0a\u5c31\u6c92\u8fa6\u6cd5\u5e6b\u4ed6\u627e\u4e86 \u525b\u525b\u624d\u60f3\u5230\u6709\u9019\u500b\u554f\u984c&#8230;Orz \u771f\u7684\u8001\u4e86 \u7db2\u8def\u4e0a\u627e\u4e86\u4e00\u4e0b\u76f8\u95dc\u7684\u554f\u984c \u4f7f\u7528\u4e0b\u5217\u5c31\u53ef\u4ee5\u89e3\u6c7a\u4e86 =SUM(IF(MOD(ROW(A1:A65535),5)=2,A1:B65535)) \u6309\u4e0bALT+SHIFT+ENTER\u8b8a\u6210\u9663\u5217\u904b\u7b97 \u5176\u4e2d\u4e3b\u8981\u662f\u7528MOD 5\u99182\u7684\u5132\u5b58\u683c\u4f86\u8a08\u7b97 \u5f8c\u9762\u7684A1:B65535\u4e3b\u8981\u5c31\u662f\u8981\u8a08\u7b97\u7684\u7bc4\u570d<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[94],"tags":[],"class_list":["post-361","post","type-post","status-publish","format-standard","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=361"}],"version-history":[{"count":1,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/361\/revisions"}],"predecessor-version":[{"id":2163,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/361\/revisions\/2163"}],"wp:attachment":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}