{"id":27,"date":"2023-07-09T12:26:51","date_gmt":"2023-07-09T03:26:51","guid":{"rendered":"https:\/\/rafa-system.com\/vba\/?p=27"},"modified":"2023-07-09T14:06:57","modified_gmt":"2023-07-09T05:06:57","slug":"post-27","status":"publish","type":"post","link":"https:\/\/rafa-system.com\/vba\/2023\/07\/09\/post-27\/","title":{"rendered":"COUNTIF(\u7bc4\u56f2, \u691c\u7d22\u6761\u4ef6)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u76ee\u7684\uff1a\u30c7\u30fc\u30bf\u306e\u5b58\u5728\u78ba\u8a8d\uff080\u306a\u3089\u5b58\u5728\u306a\u3057\u30011\u4ee5\u4e0a\u306a\u3089\u5b58\u5728\u3042\u308a\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">return\uff1a\u6570\u5024\u578b<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u7bc4\u56f2\u306e\u6307\u5b9a\u65b9\u6cd5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uff11\uff0e\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306e\u5217\u756a\u53f7or\u884c\u756a\u53f7\u3092\u6307\u5b9a\u3059\u308b<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"193\" src=\"https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-5-1024x193.png\" alt=\"\" class=\"wp-image-28\" srcset=\"https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-5-1024x193.png 1024w, https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-5-300x57.png 300w, https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-5-768x145.png 768w, https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-5.png 1351w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"173\" src=\"https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-6-1024x173.png\" alt=\"\" class=\"wp-image-29\" srcset=\"https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-6-1024x173.png 1024w, https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-6-300x51.png 300w, https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-6-768x130.png 768w, https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-6.png 1351w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uff12\uff0eRange\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6307\u5b9a\u3059\u308b\uff08\u8907\u6570\u884c\uff58\u8907\u6570\u5217\u3067\u3082\u691c\u7d22\u3067\u304d\u308b\uff09<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"215\" src=\"https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-7-1024x215.png\" alt=\"\" class=\"wp-image-30\" srcset=\"https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-7-1024x215.png 1024w, https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-7-300x63.png 300w, https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-7-768x161.png 768w, https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-7.png 1201w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u914d\u5217\u5909\u6570\u306f\u4f7f\u3048\u306a\u3044\u304c\u3001\u95a2\u6570\u3092\u81ea\u4f5c\u3059\u308c\u3070\u518d\u73fe\u306f\u53ef\u80fd<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"420\" src=\"https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-8.png\" alt=\"\" class=\"wp-image-31\" srcset=\"https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-8.png 830w, https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-8-300x152.png 300w, https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/07\/image-8-768x389.png 768w\" sizes=\"auto, (max-width: 830px) 100vw, 830px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u76ee\u7684\uff1a\u30c7\u30fc\u30bf\u306e\u5b58\u5728\u78ba\u8a8d\uff080\u306a\u3089\u5b58\u5728\u306a\u3057\u30011\u4ee5\u4e0a\u306a\u3089\u5b58\u5728\u3042\u308a\uff09 return\uff1a\u6570\u5024\u578b \u7bc4\u56f2\u306e\u6307\u5b9a\u65b9\u6cd5 \uff11\uff0e\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306e\u5217\u756a\u53f7or\u884c\u756a\u53f7\u3092\u6307\u5b9a\u3059\u308b \uff12\uff0eRange\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6307\u5b9a\u3059\u308b\uff08\u8907\u6570\u884c\uff58\u8907\u6570\u5217\u3067\u3082\u691c\u7d22\u3067\u304d\u308b\uff09 \u914d\u5217 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[6],"class_list":["post-27","post","type-post","status-publish","format-standard","hentry","category-function","tag-worksheetfunction"],"_links":{"self":[{"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/posts\/27","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/comments?post=27"}],"version-history":[{"count":2,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/posts\/27\/revisions"}],"predecessor-version":[{"id":33,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/posts\/27\/revisions\/33"}],"wp:attachment":[{"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/media?parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/categories?post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/tags?post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}