{"id":5407,"date":"2018-04-11T07:00:31","date_gmt":"2018-04-10T22:00:31","guid":{"rendered":"https:\/\/www.jimuya.com\/?p=5407"},"modified":"2018-04-11T06:15:30","modified_gmt":"2018-04-10T21:15:30","slug":"%e3%80%90excel%e3%80%91if%e3%82%84sumif%e3%81%aa%e3%81%a9%e3%81%ae%e9%96%a2%e6%95%b0%e3%81%ab%e6%97%a5%e4%bb%98%e7%af%84%e5%9b%b2%e6%9d%a1%e4%bb%b6%e3%82%92%e5%85%a5%e5%8a%9b%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.jimuya.com\/?p=5407","title":{"rendered":"\u3010Excel\u3011IF\u3084SUMIF\u306a\u3069\u306e\u95a2\u6570\u306b\u65e5\u4ed8\u7bc4\u56f2\u6761\u4ef6\u3092\u5165\u529b\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"

Excel\u3092\u4f7f\u3063\u3066\u3044\u308b\u3068\u304d\u3001<\/p>\n

\u5e74\u6708\u65e5\u3092\u4f7f\u3063\u305f\u8868\u304b\u3089\u3001<\/p>\n

\u65e5\u4ed8\u306e\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u3066\u8a08\u7b97\u3057\u305f\u3044\u3068\u304d\u3001<\/p>\n

\u3044\u3056\u3001\u95a2\u6570\u3092\u4f7f\u304a\u3046\uff01<\/p>\n

\u3068\u3001\u3084\u3063\u3066\u307f\u308b\u3068\u30fb\u30fb\u30fb<\/p>\n

 <\/p>\n

\u95a2\u6570\u306b\u65e5\u4ed8\u306e\u6761\u4ef6\u3092\u5165\u529b\u3059\u308b\u6642\u3001<\/p>\n

\u4f8b\u3048\u3070\u300e\uff14\u670810\u65e5\u4ee5\u4e0a<\/strong><\/span>\u300f\u3068\u3044\u3046\u6761\u4ef6\u3092\u5165\u529b\u3057\u305f\u3044\u5834\u5408\u3001<\/p>\n

\u300e\uff1e\uff1d\uff14\/\uff11\uff10<\/span><\/strong>\u300f\u3068\u5165\u529b\u3057\u3066\u3082\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n

 <\/p>\n

\u30a4\u30e1\u30fc\u30b8\u3068\u3057\u3066\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u8868\u3092\u4f5c\u308a\u305f\u3044\u5834\u5408\u3001<\/p>\n

\u5165\u529b\u3059\u308b\u5f0f\u306e\u65e5\u4ed8\u6761\u4ef6\u306e\u5165\u529b\u306b\u306f\u5de5\u592b\u304c\u5fc5\u8981\u306a\u3093\u3067\u3059\u3002<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

\u65e5\u4ed8\u3092\u8a08\u7b97\u5f0f\u306e\u6761\u4ef6\u306b\u5165\u529b\u3059\u308b\u5834\u5408\u306e\u30dd\u30a4\u30f3\u30c8\u306f\uff12\u3064\u3002<\/p>\n

 <\/p>\n

\uff11\uff0e\u300e\u201d<\/span>\u300f\u30c0\u30d6\u30eb\u30b3\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u3067\u62ec\u308b<\/strong><\/h2>\n

\uff12\uff0e\u300e\uff06<\/span>\u300f\u30a2\u30f3\u30c9\u3067\u3064\u306a\u3052\u307e\u3059<\/h2>\n

 <\/p>\n

 <\/p>\n

\u3053\u306e\u3088\u3046\u306b\u3057\u3066<\/p>\n

\uff14\u6708\uff11\uff10\u65e5\u4ee5\u4e0a\u3068\u3044\u3046\u5834\u5408\u306b\u306f<\/p>\n

“<\/span>>=“<\/span>&<\/span>“<\/span>4\/10“<\/span><\/span><\/p>\n

\u3053\u306e\u3088\u3046\u306b\u3057\u3066<\/p>\n

\u300e\uff1c\u30fb\uff1e\u30fb\uff1d\u300f\u3068\u3001\u300e\u65e5\u4ed8\u300f\u3092<\/p>\n

\u300e\u201d\u300f\u3067\u306f\u3055\u3080\u3088\u3046\u306b\u3059\u308b\u3093\u3067\u3059\u3002<\/p>\n

 <\/p>\n

\u3053\u308c\u304c\u5206\u304b\u308c\u3070<\/p>\n

\u65e5\u4ed8\u306e\u6761\u4ef6\u6307\u5b9a\u304c\u7c21\u5358\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

 <\/p>\n

\u304a\u4ed5\u4e8b\u3067\u3001\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8\u3067\u3001<\/p>\n

\u3054\u6d3b\u7528\u304f\u3060\u3055\u3044\u3002<\/p>\n

 <\/p>\n

\u3067\u308f\u3000\u3067\u308f<\/p>\n","protected":false},"excerpt":{"rendered":"

Excel\u3092\u4f7f\u3063\u3066\u3044\u308b\u3068\u304d\u3001 \u5e74\u6708\u65e5\u3092\u4f7f\u3063\u305f\u8868\u304b\u3089\u3001 \u65e5\u4ed8\u306e\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u3066\u8a08\u7b97\u3057\u305f\u3044\u3068\u304d\u3001 \u3044\u3056\u3001\u95a2\u6570\u3092\u4f7f\u304a\u3046\uff01 \u3068\u3001\u3084\u3063\u3066\u307f\u308b\u3068\u30fb\u30fb\u30fb   \u95a2\u6570\u306b\u65e5\u4ed8\u306e\u6761\u4ef6\u3092\u5165\u529b\u3059\u308b\u6642\u3001 \u4f8b\u3048\u3070\u300e\uff14\u670810 … <\/p>\n","protected":false},"author":1,"featured_media":5408,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1518],"tags":[77,1836,2419,76,204,205,2373,320,2425,84,2365,2417,208,2294,180],"class_list":["post-5407","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pc_excel","tag-excel","tag-if","tag-sumif","tag-76","tag-204","tag-205","tag-2373","tag-320","tag-2425","tag-84","tag-2365","tag-2417","tag-208","tag-2294","tag-180"],"_links":{"self":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/posts\/5407","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5407"}],"version-history":[{"count":0,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/posts\/5407\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/media\/5408"}],"wp:attachment":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}