{"url":"https://sinnjyounohito.hatenablog.com/entry/20140716/p1","height":"190","type":"rich","width":"100%","categories":["\u30d1\u30bd\u30b3\u30f3"],"description":"\u5bb6\u8a08\u7c3f\u3067Excel\u5b66\u7fd2\u4f1a\u3002 \u201cSum\u95a2\u6570\u201d\u201cSumIf\u95a2\u6570\u201d\u3092\u6559\u308f\u3063\u305f\u3002 \u96e3\u3057\u304f\u3066\u3001\u982d\u306e\u4e2d\u306f\u3050\u308b\u3050\u308b\u8ff7\u8d70\u3002 \u601d\u308f\u305a\u305f\u3081\u606f\u304c\u51fa\u3067\u3001\u307f\u3093\u306a\u306b\u7b11\u308f\u308c\u3066\u3057\u307e\u3063\u305f(>_ \u5bb6\u306b\u5e30\u3063\u3066\u5fa9\u7fd2\u3001\u3084\u308a\u306a\u304c\u3089\u624b\u9806\u3092\u66f8\u3044\u3066\u307f\u305f\u304c\uff1f\uff1f\uff1f sum\u95a2\u6570\uff08\u5f15\u6570\u3068\u3057\u3066\u6307\u5b9a\u3057\u305f\u6570\u5024\u3092\u3059\u3079\u3066\u5408\u8a08\uff09 C1\u301cC10\u306b\u6570\u5b57\u3092\u5165\u529b\u3057\u3066\u305d\u306e\u5408\u8a08 \u5408\u8a08\u5024\u3092\u8868\u793a\u3059\u308b\u30bb\u30eb(E1)\u3092\u9078\u629e =sum( \u3092\u5165\u529b\u3057\u3066fx(\u95a2\u6570\u306e\u633f\u5165\uff09\u3092\u30af\u30ea\u30c3\u30af \u95a2\u6570\u306e\u5f15\u6570 \u6570\u5024\uff11\u306b\u30ab\u30fc\u30bd\u30eb \u5408\u8a08\u3059\u308b\u30bb\u30eb\u3092\u9078\u629e\uff08C1\u301cC10) \u6570\u5024\uff11\u306b(C1:C10)\u3068\u8868\u793a OK\u3092\u62bc\u3059 C1\u301cC4\u3068C6\u301cC10\u306e\u5408\u8a08 \u5408\u8a08\u5024\u3092\u8868\u793a\u3059\u308b\u30bb\u30eb(E2)\u3092\u9078\u629e =sum( \u3092\u5165\u529b\u3057\u3066fx(\u95a2\u6570\u306e\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fsinnjyounohito.hatenablog.com%2Fentry%2F20140716%2Fp1\" title=\"\u5bb6\u8a08\u7c3f\u3067Excel\u5b66\u7fd2\u4f1a\uff08Sum\u95a2\u6570\u30fbSumIf\u95a2\u6570\uff09 - \u5c71\u53e3\u3070\u3042\u3070\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2014-07-16 00:00:00","version":"1.0","author_name":"sinnjyounohito","blog_url":"https://sinnjyounohito.hatenablog.com/","title":"\u5bb6\u8a08\u7c3f\u3067Excel\u5b66\u7fd2\u4f1a\uff08Sum\u95a2\u6570\u30fbSumIf\u95a2\u6570\uff09","image_url":"http://www8.plala.or.jp/kaomoji/r/o_guru.gif","blog_title":"\u5c71\u53e3\u3070\u3042\u3070\u306e\u65e5\u8a18","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/sinnjyounohito/","provider_url":"https://hatena.blog"}