{"image_url":null,"categories":["EXCEL"],"author_url":"https://blog.hatena.ne.jp/kunst1080/","description":"\u666e\u901a\u306f =COUNTA(\u7bc4\u56f2)\u3063\u3066\u3084\u308b\u3093\u3060\u3051\u308c\u3069\u3001\u305d\u3046\u3067\u306f\u306a\u304f\u3066 =COUNTIF(\u7bc4\u56f2,TRIM(\"\"))\u3063\u3066\u3084\u308b\u3002 \u30b5\u30f3\u30d7\u30eb A B 1 1 1 2 A A 3 4 =\"\" =\"\" 5 =COUNTA(A1:A4) =COUNTIF(B1:B4,TRIM(\"\")) \u4e0a\u8a18\u306e\u3088\u3046\u306a\u8a2d\u5b9a\u3067\u306f\u3001 \u300eA5\u300f\u306e\u30bb\u30eb(COUNTA)\u306f\u300c3\u300d\u306b\u306a\u3063\u3066\u3001\u300eB5\u300f\u306e\u30bb\u30eb(COUNTIF)\u306f\u300c2\u300d\u306b\u306a\u308b\u3002","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkunst1080.hatenablog.com%2Fentry%2F2013%2F05%2F30%2F233043\" title=\"\u3010EXCEL\u3011\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u3067\u7a7a\u306e\u30bb\u30eb\u3092\u6570\u3048\u308b(\u7a7a\u6587\u5b57\u306f\u30ab\u30a6\u30f3\u30c8\u3057\u306a\u3044\u65b9\u6cd5) - \u304f\u3093\u3059\u3068\u306e\u5099\u5fd8\u9332\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"\u304f\u3093\u3059\u3068\u306e\u5099\u5fd8\u9332","version":"1.0","width":"100%","blog_url":"https://kunst1080.hatenablog.com/","provider_name":"Hatena Blog","url":"https://kunst1080.hatenablog.com/entry/2013/05/30/233043","title":"\u3010EXCEL\u3011\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u3067\u7a7a\u306e\u30bb\u30eb\u3092\u6570\u3048\u308b(\u7a7a\u6587\u5b57\u306f\u30ab\u30a6\u30f3\u30c8\u3057\u306a\u3044\u65b9\u6cd5)","provider_url":"https://hatena.blog","author_name":"kunst1080","height":"190","published":"2013-05-30 23:30:43","type":"rich"}