{"id":1976,"date":"2013-11-17T18:04:52","date_gmt":"2013-11-17T09:04:52","guid":{"rendered":"http:\/\/www.minraku.net\/blog\/minraku\/?p=1976"},"modified":"2013-11-17T18:04:52","modified_gmt":"2013-11-17T09:04:52","slug":"countif%e3%81%ae%e4%bd%bf%e3%81%84%e6%96%b9","status":"publish","type":"post","link":"https:\/\/www.minraku.net\/blog\/minraku\/?p=1976","title":{"rendered":"COUNTIF\u306e\u4f7f\u3044\u65b9"},"content":{"rendered":"<p>COUNTIF(\u691c\u7d22\u7bc4\u56f2,\u691c\u7d22\u5bfe\u8c61)<\/p>\n<p><a href=\"https:\/\/www.minraku.net\/blog\/minraku\/wp-content\/uploads\/2013\/11\/20131117-5.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.minraku.net\/blog\/minraku\/wp-content\/plugins\/jquery-image-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/www.minraku.net\/blog\/minraku\/wp-content\/uploads\/2013\/11\/20131117-5-300x220.png\" alt=\"20131117-5\" width=\"300\" height=\"220\" class=\"lazy alignnone size-medium wp-image-1977\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.minraku.net\/blog\/minraku\/wp-content\/uploads\/2013\/11\/20131117-5-300x220.png\" alt=\"20131117-5\" width=\"300\" height=\"220\" class=\"alignnone size-medium wp-image-1977\" srcset=\"https:\/\/www.minraku.net\/blog\/minraku\/wp-content\/uploads\/2013\/11\/20131117-5-300x220.png 300w, https:\/\/www.minraku.net\/blog\/minraku\/wp-content\/uploads\/2013\/11\/20131117-5-1024x752.png 1024w, https:\/\/www.minraku.net\/blog\/minraku\/wp-content\/uploads\/2013\/11\/20131117-5-730x536.png 730w, https:\/\/www.minraku.net\/blog\/minraku\/wp-content\/uploads\/2013\/11\/20131117-5.png 1122w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>\u4f8b\uff1aH3\u306e\u30bb\u30eb\u5185\u5bb9<br \/>\n=COUNTIF($B$3:$B$25,G3)<br \/>\nB3:B25\u3092\u691c\u7d22\u7bc4\u56f2\u3068\u3057\u3001G3\u3092\u3001\u691c\u7d22\u6587\u5b57\u5217\u3068\u3059\u308b\u3002<br \/>\n\u3088\u3063\u3066\u3001\u300c7\u300d\u3064\u306e\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u308b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>COUNTIF(\u691c\u7d22\u7bc4\u56f2,\u691c\u7d22\u5bfe\u8c61) \u4f8b\uff1aH3\u306e\u30bb\u30eb\u5185\u5bb9 =COUNTIF($B$3:$B$25,G3) B3:B25\u3092\u691c\u7d22\u7bc4\u56f2\u3068\u3057\u3001G3\u3092\u3001\u691c\u7d22\u6587\u5b57\u5217\u3068\u3059\u308b\u3002 \u3088\u3063\u3066\u3001\u300c7\u300d\u3064\u306e\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u308b\u3002<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1976","post","type-post","status-publish","format-standard","hentry","category-it"],"_links":{"self":[{"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/posts\/1976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1976"}],"version-history":[{"count":1,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/posts\/1976\/revisions"}],"predecessor-version":[{"id":1978,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/posts\/1976\/revisions\/1978"}],"wp:attachment":[{"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}