{"id":286,"date":"2021-06-15T17:28:29","date_gmt":"2021-06-15T08:28:29","guid":{"rendered":"https:\/\/uom.co.jp\/2nd\/?p=286"},"modified":"2025-01-31T15:39:42","modified_gmt":"2025-01-31T06:39:42","slug":"sumif%e9%96%a2%e6%95%b0%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%97%e3%81%a6%e5%90%88%e8%a8%88%e3%82%92%e8%a8%88%e7%ae%97%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/uom.co.jp\/2nd\/?p=286","title":{"rendered":"SUMIF\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u5408\u8a08\u3092\u8a08\u7b97\u3059\u308b"},"content":{"rendered":"<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-left\" data-col=\"gray\"><div class=\"c-balloon__icon -circle\"><img loading=\"lazy\" src=\"https:\/\/uom.co.jp\/2nd\/wp-content\/uploads\/2021\/02\/4388907_m.jpg\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><\/div><div class=\"c-balloon__body -speaking -border-none\"><div class=\"c-balloon__text\">\n<p>\u304a\u306f\u3088\u3046\u3054\u3056\u3044\u307e\u3059\uff01\u3053\u3093\u306b\u3061\u306f\uff01\u3053\u3093\u3070\u3093\u308f&#x1f43e;<br>\u672c\u65e5\u3082\u95b2\u89a7\u3044\u305f\u3060\u304d\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002<br><br><span class=\"swl-marker mark_orange\">\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u3066\u5408\u8a08\u3092\u51fa\u3057\u305f\u3044\u3068\u304d\u306e\u5b9a\u756a\u306f<span class=\"has-inline-color has-swl-deep-01-color\"><strong>\u300cSUMIF\u300d\uff08\u30b5\u30e0\u30fb\u30a4\u30d5\uff09\u95a2\u6570<\/strong><\/span>\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/span>\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3092\u8aac\u660e\u81f4\u3057\u307e\u3059\u306e\u3067\u3001\u662f\u975e\u6700\u5f8c\u307e\u3067\u898b\u3066\u3044\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2>SUMIF\u95a2\u6570\u306e\u4f7f\u3044\u65b9<\/h2>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container\">\n<ol class=\"is-style-check_list\"><li><span class=\"swl-marker mark_orange\">\u5408\u8a08\u5024\u3092\u8868\u793a\u3057\u305f\u3044\u30bb\u30eb\u306b\u300c<span class=\"has-inline-color has-swl-deep-01-color\">=SUMIF(<\/span>\u300d\u3068\u5165\u529b<\/span>\u3057\u307e\u3059<\/li><li>\u691c\u7d22\u306e\u5bfe\u8c61\u3068\u3059\u308b\u30bb\u30eb\u7bc4\u56f2\u3092\u9078\u629e\u3092\u3057\u307e\u3059\uff08<span class=\"has-inline-color has-swl-deep-01-color\">\uff3b\u7bc4\u56f2\uff3d\u306e\u8a2d\u5b9a<\/span>\uff09<\/li><li><span class=\"swl-marker mark_orange\">\uff3b\u7bc4\u56f2\uff3d\u306e\u4e2d\u306b\u3042\u308b\u691c\u7d22\u6761\u4ef6\u3092\u6587\u5b57\u5217\u3084\u6570\u5024\u3067\u6307\u5b9a<\/span>\u3057\u307e\u3059\uff08<span class=\"has-inline-color has-swl-deep-01-color\">\uff3b\u691c\u7d22\u6761\u4ef6\uff3d\u306e\u8a2d\u5b9a<\/span>\uff09<\/li><li>\u5408\u8a08\u3057\u305f\u3044\u5024\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\uff08<span class=\"has-inline-color has-swl-deep-01-color\">\uff3b\u5408\u8a08\u7bc4\u56f2\uff3d\u306e\u8a2d\u5b9a<\/span>\uff09<\/li><li><span class=\"swl-marker mark_orange\">\u6700\u5f8c\u306b<span class=\"has-inline-color has-swl-deep-01-color\">\u300c)\u300d\uff08\u534a\u89d2\u9589\u3058\u30ab\u30c3\u30b3\uff09\u3092\u5165\u529b<\/span>\u3057\u3066Enter<\/span>\u30ad\u30fc\u3092\u62bc\u3059<\/li><\/ol>\n<\/div><\/div>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"749\" height=\"428\" src=\"https:\/\/uom.co.jp\/2nd\/wp-content\/uploads\/2021\/02\/sumif.jpg\" alt=\"\" class=\"wp-image-307\" srcset=\"https:\/\/uom.co.jp\/2nd\/wp-content\/uploads\/2021\/02\/sumif.jpg 749w, https:\/\/uom.co.jp\/2nd\/wp-content\/uploads\/2021\/02\/sumif-300x171.jpg 300w\" sizes=\"(max-width: 749px) 100vw, 749px\" \/><\/figure>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-left\" data-col=\"gray\"><div class=\"c-balloon__icon -circle\"><img loading=\"lazy\" src=\"https:\/\/uom.co.jp\/2nd\/wp-content\/uploads\/2021\/02\/4388907_m.jpg\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><\/div><div class=\"c-balloon__body -speaking -border-none\"><div class=\"c-balloon__text\">\n<p>\u3069\u3046\u3067\u3057\u305f\u304b\uff1f\u610f\u5916\u3068\u7c21\u5358\u306b\u3067\u304d\u305f\u3068\u601d\u3044\u307e\u3059\u3002<br>\u6b21\u56de\u306f\u3001\u300c<span class=\"has-inline-color has-swl-deep-01-color\"><strong>SUMIFS<\/strong><\/span>\u300d\u95a2\u6570\u306b\u3064\u3044\u3066\u3054\u8aac\u660e\u3055\u305b\u3066\u3044\u305f\u3060\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002\u662f\u975e\u3001\u8db3\u3092\u904b\u3093\u3067\u3044\u3063\u3066\u304f\u3060\u3055\u3044\u306d\uff5e&#x1f43e;&#x1f43e;<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n\n\n","protected":false},"excerpt":{"rendered":"<p>SUMIF\u95a2\u6570\u306e\u4f7f\u3044\u65b9 \u5408\u8a08\u5024\u3092\u8868\u793a\u3057\u305f\u3044\u30bb\u30eb\u306b\u300c=SUMIF(\u300d\u3068\u5165\u529b\u3057\u307e\u3059 \u691c\u7d22\u306e\u5bfe\u8c61\u3068\u3059\u308b\u30bb\u30eb\u7bc4\u56f2\u3092\u9078\u629e\u3092\u3057\u307e\u3059\uff08\uff3b\u7bc4\u56f2\uff3d\u306e\u8a2d\u5b9a\uff09 \uff3b\u7bc4\u56f2\uff3d\u306e\u4e2d\u306b\u3042\u308b\u691c\u7d22\u6761\u4ef6\u3092\u6587\u5b57\u5217\u3084\u6570\u5024\u3067\u6307\u5b9a\u3057\u307e\u3059\uff08\uff3b\u691c\u7d22\u6761\u4ef6\uff3d\u306e\u8a2d\u5b9a\uff09 \u5408\u8a08\u3057 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":290,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":""},"categories":[10],"tags":[],"_links":{"self":[{"href":"https:\/\/uom.co.jp\/2nd\/index.php?rest_route=\/wp\/v2\/posts\/286"}],"collection":[{"href":"https:\/\/uom.co.jp\/2nd\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/uom.co.jp\/2nd\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/uom.co.jp\/2nd\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/uom.co.jp\/2nd\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=286"}],"version-history":[{"count":14,"href":"https:\/\/uom.co.jp\/2nd\/index.php?rest_route=\/wp\/v2\/posts\/286\/revisions"}],"predecessor-version":[{"id":547,"href":"https:\/\/uom.co.jp\/2nd\/index.php?rest_route=\/wp\/v2\/posts\/286\/revisions\/547"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/uom.co.jp\/2nd\/index.php?rest_route=\/wp\/v2\/media\/290"}],"wp:attachment":[{"href":"https:\/\/uom.co.jp\/2nd\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/uom.co.jp\/2nd\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/uom.co.jp\/2nd\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}