{"id":18151,"date":"2023-07-15T16:45:00","date_gmt":"2023-07-15T07:45:00","guid":{"rendered":"https:\/\/www.mizutan.com\/wordpress\/?p=18151"},"modified":"2024-12-12T18:40:11","modified_gmt":"2024-12-12T09:40:11","slug":"post-18151","status":"publish","type":"post","link":"https:\/\/www.mizutan.com\/wordpress\/?p=18151","title":{"rendered":"\u30a8\u30af\u30bb\u30eb\u3067\u9805\u76ee\u3054\u3068\u306e\u96c6\u8a08\u3092\u8907\u6570\u6761\u4ef6\u3092\u4ed8\u52a0\u3057\u3066\u5b9f\u65bd\u3059\u308b\u306e\u306b\u4f7f\u3046\u95a2\u6570"},"content":{"rendered":"\n<p>\u30a8\u30af\u30bb\u30eb\u306f\u96c6\u8a08\u3092\u53d6\u308b\u306e\u304c\u51c4\u304f\u7c21\u5358\u3067\u3059\u3088\u306d\u3002\u5358\u7d14\u96c6\u8a08\u306a\u3089SUM\u95a2\u6570\u3067\u4e00\u767a\u3067\u3059\u3002<br><br>\u3053\u306e<strong>\u96c6\u8a08\u3092\u53d6\u308b\u306e\u306b\u6761\u4ef6\u3092\u4ed8\u52a0\u3057\u3066\u5b9f\u65bd\u3059\u308b\u65b9\u6cd5<\/strong>\u3092\u3054\u5b58\u77e5\u3067\u3059\u304b\u3002<br><br>\u4e00\u3064\u306e\u6761\u4ef6\u3092\u4ed8\u52a0\u3057\u3066\u5408\u8a08\u3092\u53d6\u308b\u95a2\u6570\u306a\u3089\u77e5\u3063\u3066\u3044\u307e\u3059\u3002SUMIF\u95a2\u6570\u3067\u3059\u306d\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-balloon vk_balloon vk_balloon-position-left vk_balloon-type-speech vk_balloon-animation-none\"><div class=\"vk_balloon_icon\"><figure><img decoding=\"async\" class=\"vk_balloon_icon_image vk_balloon_icon_image-type-normal \" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2018\/10\/fukidasi.jpg\" alt=\"\"\/><figcaption class=\"vk_balloon_icon_name\">60\u723a<\/figcaption><\/figure><\/div><div class=\"vk_balloon_content_outer\"><div class=\"vk_balloon_content  \"><span class=\"vk_balloon_content_before \"><\/span><span class=\"vk_balloon_content_after \"><\/span>\n<p>\u6614\u304b\u3089\u3001\u8907\u6570\u6761\u4ef6\u3092\u6307\u5b9a\u3067\u304d\u306a\u3044\u30e2\u30ce\u304b\u3068\u601d\u3063\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n<\/div><\/div><\/div>\n\n\n\n<p>\u305d\u3046\u3057\u305f\u3089\u3001<strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#fe0000\" class=\"has-inline-color\">\u4f55\u3068\u305d\u308c\u3092\u884c\u3046\u95a2\u6570\u304c\u3042\u308b\u3068\u306e\u6717\u5831\u304c\u805e\u3053\u3048\u3066\u304d\u307e\u3057\u305f<\/mark><\/strong>\u3088\u3002<br><br>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001<span data-color=\"#ffff00\" style=\"background: linear-gradient(transparent 60%,rgba(255, 255, 0, 0.7) 0);\" class=\"vk_highlighter\">\u30a8\u30af\u30bb\u30eb\u3067\u9805\u76ee\u3054\u3068\u306e\u96c6\u8a08\u3092\u8907\u6570\u6761\u4ef6\u3092\u4ed8\u52a0\u3057\u3066\u5b9f\u65bd\u3059\u308b\u306e\u306b\u4f7f\u3046\u95a2\u6570\u306b\u3064\u3044\u3066\u89e3\u8aac<\/span>\u3057\u3066\u3044\u304d\u307e\u3059\u3002<br><br>\u3058\u3063\u304f\u308a\u8aad\u307f\u8fbc\u3093\u3067\u304f\u3060\u3055\u3044\u306d\u3002<\/p>\n\n\n\n<!-- WP QUADS v. 2.0.98  Shortcode Ad -->\n<div class=\"quads-location quads-ad\" id=\"quads-ad\" style=\"float:none;margin:0px 0 0px 0;text-align:center;\">\n\u30b9\u30dd\u30f3\u30b5\u30fc\u30ea\u30f3\u30af\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1169427325398969\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- www_\u30a4\u30f3\u30c8\u30ed -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-1169427325398969\"\r\n     data-ad-slot=\"1208333098\"\r\n     data-ad-format=\"rectangle\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><br><\/div>\n\n\n\n\n<h2 class=\"wp-block-heading is-style-vk-heading-double_black\">\u30a8\u30af\u30bb\u30eb\u3067\u9805\u76ee\u3054\u3068\u306e\u96c6\u8a08\u3092\u8907\u6570\u6761\u4ef6\u3092\u4ed8\u52a0\u3057\u3066\u5b9f\u65bd\u3059\u308b\u95a2\u6570\u540d<\/h2>\n\n\n\n<p>\u3055\u3066\u3001\u59cb\u3081\u306b\u3001\u3053\u306e\u4fbf\u5229\u306a\u95a2\u6570\u3092\u304a\u77e5\u3089\u305b\u3057\u3061\u3083\u3044\u307e\u3057\u3087\u3046\uff01<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-border-box vk_borderBox vk_borderBox-background-transparent is-style-vk_borderBox-style-solid-kado-tit-tab\"><div class=\"vk_borderBox_title_container\"><i class=\"\"><\/i><h4 class=\"vk_borderBox_title\">\u30a8\u30af\u30bb\u30eb\u3067\u9805\u76ee\u3054\u3068\u306e\u96c6\u8a08\u3092\u8907\u6570\u6761\u4ef6\u3092\u4ed8\u52a0\u3057\u3066\u5b9f\u65bd\u3059\u308b\u95a2\u6570\u540d<\/h4><\/div><div class=\"vk_borderBox_body\">\n<p>\u9805\u76ee\u3054\u3068\u306e\u96c6\u8a08\u3092\u30012\u3064\u4ee5\u4e0a\u306e\u8907\u6570\u6761\u4ef6\u3092\u6e80\u305f\u3057\u3066\u6c42\u3081\u308b\u306e\u306b\u4f7f\u7528\u3059\u308b\u95a2\u6570\u540d\u306f\u6b21\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-luxe-blocks-border-block\" style=\"margin-top:10px;margin-bottom:30px\"><div class=\"wp-block-luxe-blocks-border-block-content\" style=\"border:4px solid #006edc;border-radius:0px;padding:0px 15px 0px 15px\"><p>SUMIFS\u95a2\u6570<\/p><\/div><\/div>\n\n\n\n<p>\u3053\u306eSUMIFS\u95a2\u6570\u306f\u3001Excel2007\u4ee5\u964d\u3067\u4f7f\u7528\u3067\u304d\u308b\u95a2\u6570\u3067\u3059\u306d\u3002<br><br>\u5192\u982d\u3067\u8ff0\u3079\u305fSUMIF\u95a2\u6570\u3068\u306e\u9055\u3044\u306f\u6b21\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-vk-table-border-stripes\"><table><thead><tr><th>\u95a2\u6570\u540d<\/th><th>\u6761\u4ef6\u304c1\u3064<\/th><th>\u6761\u4ef6\u304c\u8907\u6570<\/th><th>\u3044\u3064\u304b\u3089\u4f7f\u3048\u308b<\/th><\/tr><\/thead><tbody><tr><td>SUMIF<\/td><td>\u25cb<\/td><td>\u00d7<\/td><td>\u6614\u306eExcel\u304b\u3089<\/td><\/tr><tr><td>SUMIFS<\/td><td>\u25cb<\/td><td>\u25cb<\/td><td>Excel 2007\u304b\u3089\u4f7f\u3048\u308b<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div><\/div>\n\n\n\n<p>\u305d\u308c\u3067\u306f\u3001\u3053\u306eSUMIFS\u95a2\u6570\u3067\u300c\u9805\u76ee\u3054\u3068\u306e\u96c6\u8a08\u3092\u8907\u6570\u6761\u4ef6\u3092\u4ed8\u52a0\u3057\u3066\u5b9f\u65bd\u3059\u308b\u300d\u624b\u9806\u3092\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30d9\u30fc\u30b9\u3068\u306a\u308b\u8868\u306e\u78ba\u8a8d<\/h3>\n\n\n\n<p>\u6b21\u306e\u3088\u3046\u306a\u8868\u304c\u3042\u308a\u307e\u3059\u3002<br><br>\u3053\u306e\u8868\u3092\u30d9\u30fc\u30b9\u3068\u3057\u3066\u3001\u9805\u76ee\u3054\u3068\u306e\u96c6\u8a08\u3092\u8907\u6570\u6761\u4ef6\u3092\u4ed8\u52a0\u3057\u3066\u5b9f\u65bd\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"293\" height=\"400\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_01_1.jpg\" alt=\"\" class=\"wp-image-18152\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_01_1.jpg 293w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_01_1-220x300.jpg 220w\" sizes=\"auto, (max-width: 293px) 100vw, 293px\" \/><\/figure>\n<\/div>\n\n\n<p>\u307e\u305a\u306f\u3001\u7c21\u5358\u306a\u3082\u306e\u304b\u3089\u59cb\u3081\u307e\u3057\u3087\u3046\u3002<br><br>\u4eca\u56de\u306e\u96c6\u8a08\u306f\u3001\u6b21\u306e2\u3064\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u5185\u5bb9\u306e\u91d1\u984d\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-vk-table-border-stripes\"><table><thead><tr><th>\u6761\u4ef6<\/th><th>\u6761\u4ef6\u306e\u5185\u5bb9<\/th><th class=\"has-text-align-center\" data-align=\"center\">\u5217<\/th><\/tr><\/thead><tbody><tr><td>\u6761\u4ef61<\/td><td>\u8cfc\u5165\u7269\u4ef6\uff1d\u300c\u98df\u3079\u7269\u300d<\/td><td class=\"has-text-align-center\" data-align=\"center\">B<\/td><\/tr><tr><td>\u6761\u4ef62<\/td><td>\u8a73\u7d30\uff1d\u300c\u548c\u83d3\u5b50\u300d<\/td><td class=\"has-text-align-center\" data-align=\"center\">C<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u307e\u305a\u3001\u30d9\u30fc\u30b9\u8868\u306e\u4e0b\u306b\u5408\u8a08\u862d\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"336\" height=\"104\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_02.jpg\" alt=\"\" class=\"wp-image-18153\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_02.jpg 336w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_02-300x93.jpg 300w\" sizes=\"auto, (max-width: 336px) 100vw, 336px\" \/><\/figure>\n<\/div>\n\n\n<p>\u8cfc\u5165\u7269\u4ef6\u306b\u300c\u98df\u3079\u7269\u300d\u3001\u8a73\u7d30\u306b\u300c\u548c\u83d3\u5b50\u300d\u3001\u305d\u3057\u3066\u5408\u8a08\u862d\uff08\u8d64\u77e2\u5370\uff09\u300c\u30bb\u30ebD18\u300d\u306b\u95a2\u6570\u3092\u5165\u308c\u3066\u96c6\u8a08\u3092\u53d6\u308b\u3053\u3068\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<!-- WP QUADS v. 2.0.98  Shortcode Ad -->\n<div class=\"quads-location quads-ad\" id=\"quads-ad\" style=\"float:none;margin:0px 0 0px 0;text-align:center;\">\n\u30b9\u30dd\u30f3\u30b5\u30fc\u30ea\u30f3\u30af\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1169427325398969\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block; text-align:center;\"\r\n     data-ad-layout=\"in-article\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-client=\"ca-pub-1169427325398969\"\r\n     data-ad-slot=\"8169621401\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><br><\/div>\n\n\n\n\n<h3 class=\"wp-block-heading\">SUMIFS\u95a2\u6570\u5f15\u6570\u5165\u529b\u753b\u9762\u306e\u8868\u793a<\/h3>\n\n\n\n<p>\u305d\u308c\u3067\u306f\u3001SUMIFS\u95a2\u6570\u3078\u306e\u5165\u529b\u624b\u9806\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002\u76f4\u63a5\u3001\u95a2\u6570\u3092\u305f\u305f\u304f\u65b9\u6cd5\u3082\u3042\u308b\u3093\u3067\u3059\u304c\u3001\u521d\u3081\u3066\u306e\u5834\u5408\u3001\u3061\u3087\u3063\u3068\u6577\u5c45\u304c\u9ad8\u3044\u3067\u3059\u3002<br><br>\u307e\u305a\u306f\u3001<span data-color=\"#ffff00\" style=\"background: linear-gradient(transparent 60%,rgba(255, 255, 0, 0.7) 0);\" class=\"vk_highlighter\">\u300c\u95a2\u6570\u306e\u633f\u5165\u300d\u753b\u9762\u3092\u4f7f\u7528\u3057\u3066\u3001SUMIFS\u95a2\u6570\u5f15\u6570\u5165\u529b\u753b\u9762\u3092\u8868\u793a\u3057\u3066\u304b\u3089\u3001\u5f15\u6570\u3092\u5165\u529b\u3059\u308b\u65b9\u6cd5\u304c\u5206\u304b\u308a\u3084\u3059\u3044<\/span>\u3067\u3059\u3002<br><br>\u305d\u306e\u624b\u9806\u3092\u793a\u3057\u307e\u3059\u3002<br><br>\u3055\u3066\u3001\u5148\u7a0b\u306e\u96c6\u8a08\u862d\uff08\u30bb\u30ebD18\uff09\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u30bb\u30c3\u30c8\u3057\u305f\u5f8c\u3001\u6570\u5f0f\u30d0\u30fc\u306b\u3042\u308b\u300c\u95a2\u6570\u306e\u633f\u5165\u300d\u30de\u30fc\u30af\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"321\" height=\"112\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_03.jpg\" alt=\"\" class=\"wp-image-18154\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_03.jpg 321w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_03-300x105.jpg 300w\" sizes=\"auto, (max-width: 321px) 100vw, 321px\" \/><\/figure>\n<\/div>\n\n\n<p>\u3059\u308b\u3068\u3001\u300c\u95a2\u6570\u306e\u633f\u5165\u300d\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u3053\u306e\u3068\u304d\u3001\u30bb\u30ebD18\u3068\u6570\u5f0f\u30d0\u30fc\u306b\u81ea\u52d5\u7684\u306b&#8221;=&#8221;\u304c\u633f\u5165\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"387\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_04.jpg\" alt=\"\" class=\"wp-image-18155\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_04.jpg 400w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_04-300x290.jpg 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/figure>\n<\/div>\n\n\n<p>SUMIFS\u95a2\u6570\u3092\u300c\u95a2\u6570\u540d\u300d\u304b\u3089\u9078\u629e\u3059\u308b\u3093\u3067\u3059\u304c\u3001\u95a2\u6570\u304c\u305f\u304f\u3055\u3093\u3042\u3063\u3066\u5927\u5909\u306a\u306e\u3067\u3001\u95a2\u6570\u306e\u691c\u7d22\u306b s \u3092\u5165\u308c\u3066\u691c\u7d22\u958b\u59cb\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"421\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_04_1.jpg\" alt=\"\" class=\"wp-image-18156\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_04_1.jpg 435w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_04_1-300x290.jpg 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/figure>\n<\/div>\n\n\n<p>\u3059\u308b\u3068\u3001S\u3067\u59cb\u307e\u308b\u95a2\u6570\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002SUMIFS\u3092\u9078\u629e\u3057\u3066OK\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-gallery aligncenter has-nested-images columns-default is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"421\" data-id=\"18157\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_04_2.jpg\" alt=\"\" class=\"wp-image-18157\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_04_2.jpg 435w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_04_2-300x290.jpg 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"421\" data-id=\"18158\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_05.jpg\" alt=\"\" class=\"wp-image-18158\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_05.jpg 435w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_05-300x290.jpg 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/figure>\n<\/figure>\n\n\n\n<p>\u300c\u95a2\u6570\u306e\u5f15\u6570\u300d\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002SUMIFS\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306e\u6e96\u5099\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_06.jpg\" alt=\"\" class=\"wp-image-18159\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_06.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_06-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n<\/div>\n\n\n<!-- WP QUADS v. 2.0.98  Shortcode Ad -->\n<div class=\"quads-location quads-ad\" id=\"quads-ad\" style=\"float:none;margin:0px 0 0px 0;text-align:center;\">\n\u30b9\u30dd\u30f3\u30b5\u30fc\u30ea\u30f3\u30af\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1169427325398969\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block; text-align:center;\"\r\n     data-ad-layout=\"in-article\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-client=\"ca-pub-1169427325398969\"\r\n     data-ad-slot=\"9186857477\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/div>\n\n\n\n\n<h3 class=\"wp-block-heading\">SUMIFS\u95a2\u6570\u5f15\u6570\u5165\u529b<\/h3>\n\n\n\n<p>SUMUIFS\u95a2\u6570\u306e\u300c\u95a2\u6570\u306e\u5f15\u6570\u300d\u753b\u9762\u306b\u3042\u308b\u5f15\u6570\uff08\u5408\u8a08\u5bfe\u8c61\u7bc4\u56f2\u53ca\u3073\u6761\u4ef6\u7bc4\u56f21\u2026\u2026\uff09\u3092\u9806\u306b\u5165\u529b\u3057\u3066\u3044\u304d\u307e\u3059\u3002<br><br>\u307e\u305a\u3001\u5024\u6bb5\u306e\u30c8\u30c3\u30d7\u3067\u3042\u308b\u30bb\u30ebD2\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"385\" height=\"340\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_07.jpg\" alt=\"\" class=\"wp-image-18166\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_07.jpg 385w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_07-300x265.jpg 300w\" sizes=\"auto, (max-width: 385px) 100vw, 385px\" \/><\/figure>\n<\/div>\n\n\n<p>\u30de\u30a6\u30b9\u3092\u96e2\u3055\u305a\u306b\u3001\u5408\u8a08\u306e\u6700\u5f8c\u3067\u3042\u308b\u30bb\u30ebD16\u307e\u3067\u30ab\u30fc\u30bd\u30eb\u3092\u79fb\u52d5\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"251\" height=\"474\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_08.jpg\" alt=\"\" class=\"wp-image-18167\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_08.jpg 251w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_08-159x300.jpg 159w\" sizes=\"auto, (max-width: 251px) 100vw, 251px\" \/><\/figure>\n<\/div>\n\n\n<p>\u3054\u89a7\u306e\u3088\u3046\u306b\u3001\u5f15\u6570\u306e\u6b04\u306b\u300cD2:D16\u300d\u304c\u8a2d\u5b9a\u3055\u308c\u307e\u3059\u3002<br><br>\u30ab\u30fc\u30bd\u30eb\u3092\u96e2\u3059\u3068\u3001\u300c\u95a2\u6570\u306e\u5f15\u6570\u300d\u753b\u9762\u306e\u5408\u8a08\u5bfe\u8c61\u7bc4\u56f2\u306b\u300cD2:D16\u300d\u304c\u8a2d\u5b9a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_09.jpg\" alt=\"\" class=\"wp-image-18168\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_09.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_09-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n<\/div>\n\n\n<p>\u6b21\u306b\u3001\u6761\u4ef6\u7bc4\u56f21\u306e\u5165\u529b\u3067\u3059\u3002\u6761\u4ef6\u7bc4\u56f21\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002\u3059\u308b\u3068\u3001\u6761\u4ef6\u7bc4\u56f21\u306e\u4e0b\u306b\u65b0\u305f\u306a\u5f15\u6570\u3067\u3042\u308b\u6761\u4ef61\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_10.jpg\" alt=\"\" class=\"wp-image-18169\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_10.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_10-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n<\/div>\n\n\n<p>\u5408\u8a08\u7bc4\u56f2\u306e\u6642\u3068\u540c\u69d8\u306b\u3001\u30ab\u30fc\u30bd\u30eb\u3092\u30bb\u30ebB2\u3078\u304a\u304d\u3001\u30bb\u30ebB16\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_11.jpg\" alt=\"\" class=\"wp-image-18170\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_11.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_11-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n<\/div>\n\n\n<p>\u30ab\u30fc\u30bd\u30eb\u3092\u96e2\u3059\u3068\u3001\u300c\u95a2\u6570\u306e\u5f15\u6570\u300d\u753b\u9762\u306e\u6761\u4ef6\u7bc4\u56f21\u306b\u300cB2:B16\u300d\u304c\u8a2d\u5b9a\u3055\u308c\u307e\u3059\u3002<br><br>\u6b21\u306b\u3001\u6761\u4ef61\u306e\u5165\u529b\u3067\u3059\u3002\u6761\u4ef61\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002\u3059\u308b\u3068\u3001\u6761\u4ef61\u306e\u4e0b\u306b\u65b0\u305f\u306a\u5f15\u6570\u3067\u3042\u308b\u6761\u4ef6\u7bc4\u56f22\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_12.jpg\" alt=\"\" class=\"wp-image-18171\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_12.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_12-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n<\/div>\n\n\n<p>\u3055\u3066\u3001\u6761\u4ef61\u306e\u5165\u529b\u3067\u3059\u3002\u3053\u3053\u306b\u306f\u3001\u76f4\u63a5&#8221;\u98df\u3079\u7269&#8221;\u3068\u5165\u529b\u3057\u3066\u3082\u826f\u3044\u306e\u3067\u3059\u304c\u3001\u305b\u3063\u304b\u304f\u3001\u898b\u51fa\u3057\u304c\u5165\u308c\u3066\u3042\u308b\u306e\u3067\u3059\u304b\u3089\u3001\u305d\u306e\u5185\u5bb9\u3092\u30bb\u30c3\u30c8\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"336\" height=\"104\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_02.jpg\" alt=\"\" class=\"wp-image-18153\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_02.jpg 336w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_02-300x93.jpg 300w\" sizes=\"auto, (max-width: 336px) 100vw, 336px\" \/><\/figure>\n<\/div>\n\n\n<p>\u65e2\u306b\u304a\u898b\u305b\u3057\u305f\u5408\u8a08\u862d\u306b\u3042\u308b\u898b\u51fa\u3057\u306b\u300c\u98df\u3079\u7269\u300d\uff08\u30bb\u30ebB18\uff09\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u306e\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u6761\u4ef61\u306b\u30bb\u30eb\u306e\u5185\u5bb9\u304c\u30bb\u30c3\u30c8\u3055\u308c\u308b\u306e\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_13.jpg\" alt=\"\" class=\"wp-image-18172\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_13.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_13-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n<\/div>\n\n\n<p>\u6b21\u306b\u3001\u6761\u4ef6\u7bc4\u56f22\u306e\u5165\u529b\u3067\u3059\u3002\u6761\u4ef6\u7bc4\u56f22\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002\u3059\u308b\u3068\u3001\u6761\u4ef6\u7bc4\u56f22\u306e\u4e0b\u306b\u65b0\u305f\u306a\u5f15\u6570\u3067\u3042\u308b\u6761\u4ef62\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_13_1.jpg\" alt=\"\" class=\"wp-image-18174\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_13_1.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_13_1-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n<\/div>\n\n\n<p>\u5408\u8a08\u7bc4\u56f2\u3001\u6761\u4ef6\u7bc4\u56f21\u306e\u6642\u3068\u540c\u69d8\u306b\u3001\u30ab\u30fc\u30bd\u30eb\u3092\u30bb\u30ebC2\u3078\u304a\u304d\u3001\u30bb\u30ebC16\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_14.jpg\" alt=\"\" class=\"wp-image-18173\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_14.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_14-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n<\/div>\n\n\n<p>\u30ab\u30fc\u30bd\u30eb\u3092\u96e2\u3059\u3068\u3001\u300c\u95a2\u6570\u306e\u5f15\u6570\u300d\u753b\u9762\u306e\u6761\u4ef6\u7bc4\u56f21\u306b\u300cB2:B16\u300d\u304c\u8a2d\u5b9a\u3055\u308c\u307e\u3059\u3002<br><br>\u6b21\u306b\u3001\u6761\u4ef61\u306e\u5165\u529b\u3067\u3059\u3002\u6761\u4ef62\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002\u4eca\u5ea6\u306f\u3001\u65b0\u305f\u306a\u5f15\u6570\u306f\u8868\u793a\u3055\u308c\u307e\u305b\u3093\u3002<br><br>\u6761\u4ef62\u3092\u5165\u529b\u3057\u307e\u3059\u3002\u6761\u4ef61\u3068\u540c\u69d8\u306b\u3001\u76f4\u63a5&#8221;\u548c\u83d3\u5b50&#8221;\u3068\u306f\u305b\u305a\u3001\u305b\u3063\u304b\u304f\u3001\u898b\u51fa\u3057\u304c\u5165\u308c\u3066\u3042\u308b\u306e\u3067\u3059\u304b\u3089\u3001\u305d\u306e\u5185\u5bb9\u3092\u30bb\u30c3\u30c8\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"336\" height=\"104\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_02.jpg\" alt=\"\" class=\"wp-image-18153\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_02.jpg 336w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_02-300x93.jpg 300w\" sizes=\"auto, (max-width: 336px) 100vw, 336px\" \/><\/figure>\n<\/div>\n\n\n<p>\u5408\u8a08\u862d\u306b\u3042\u308b\u898b\u51fa\u3057\u306e\u300c\u548c\u83d3\u5b50\u300d\uff08\u30bb\u30ebC18\uff09\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u306e\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u6761\u4ef62\u306bC18\u3092\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_15.jpg\" alt=\"\" class=\"wp-image-18176\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_15.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_15-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n<\/div>\n\n\n<p>\u300cOK\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30bb\u30ebD18\u306b\u6761\u4ef6\u8fbc\u307f\u306e\u5408\u8a08\u91d1\u984d\u304c\u30bb\u30c3\u30c8\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"464\" height=\"480\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_16_2.jpg\" alt=\"\" class=\"wp-image-18178\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_16_2.jpg 464w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_16_2-290x300.jpg 290w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/figure>\n<\/div>\n\n\n<p>\u5408\u8a08\u91d1\u984d4,920\u3092\u691c\u7b97\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\uff085\/3\uff091,260 +\uff085\/15\uff092,160 + \uff085\/22\uff091,500 = 4,920 \u3068\u306a\u308a\u5408\u3063\u3066\u3044\u307e\u3059\u306d\uff5e\uff08\u307e\u3042\u3001\u5f53\u305f\u308a\u524d\u3067\u3059\u304c\uff65\uff65\uff65\uff09\uff01<br><br>\u305d\u3057\u3066\u3001\u8d64\u67a0\u3067\u56f2\u3093\u3060\u5185\u5bb9\u304c\u3001\u4eca\u56de\u4f5c\u6210\u3055\u308c\u305fSUMIFS\u95a2\u6570\u306e\u4e2d\u8eab\u3067\u3059\uff01 <\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=SUMIFS(D2:D16,B2:B16,B18,C2:C16,C18)<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u3053\u308c\u306f\u4fbf\u5229<\/h3>\n\n\n\n<p>\u3055\u3066\u3001SUMIF\u95a2\u6570\u306e\u5f15\u6570\u3092\u5165\u308c\u305f\u969b\u3001\u6761\u4ef61\u53ca\u3073\u6761\u4ef62\u3067\u76f4\u63a5\u5024\u3092\u6253\u3061\u8fbc\u307e\u305a\u306b\u30bb\u30eb\u306e\u5024\u3092\u8a2d\u5b9a\u3057\u307e\u3057\u305f\u3002\u3053\u3046\u3057\u305f\u3053\u3068\u3067\u3001\u6b21\u306e\u3088\u3046\u306b\u4fbf\u5229\u306a\u4f7f\u3044\u65b9\u304c\u51fa\u6765\u307e\u3059\u3002<br><br>\u5408\u8a08\u884c\u306e\u300c\u548c\u83d3\u5b50\u300d\u3092\u300c\u304a\u5f01\u5f53\u300d\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"233\" height=\"51\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_32.jpg\" alt=\"\" class=\"wp-image-18184\"\/><\/figure>\n<\/div>\n\n\n<p>\u3059\u308b\u3068\u3001\u300c\u98df\u3079\u7269\u300d\uff06\u300c\u304a\u5f01\u5f53\u300d\u306e\u5408\u8a08\u304c\u51fa\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"480\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_33_1.jpg\" alt=\"\" class=\"wp-image-18187\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_33_1.jpg 471w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_33_1-294x300.jpg 294w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_33_1-75x75.jpg 75w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n<\/div>\n\n\n<p>SUMIFS\u306e\u4e2d\u8eab\u306f\u5168\u304f\u5909\u308f\u3063\u3066\u3044\u307e\u305b\u3093\u304c\u3001\u5408\u8a08\u884c\u306e\u5185\u5bb9\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u6761\u4ef6\u306b\u898b\u5408\u3063\u305f\u96c6\u8a08\u3092\u5f97\u308b\u3053\u3068\u304c\u51fa\u6765\u308b\u3093\u3067\u3059\u3002<br><br>\u6b21\u306e\u4f8b\u306f\u3001\u300c\u66f8\u7c4d\u300d\uff06\u300c\u96d1\u8a8c\u300d\u306b\u5909\u66f4\u3057\u305f\u5834\u5408\u3067\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"472\" height=\"480\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_34.jpg\" alt=\"\" class=\"wp-image-18186\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_34.jpg 472w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_34-295x300.jpg 295w\" sizes=\"auto, (max-width: 472px) 100vw, 472px\" \/><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\">\u304a\u307e\u3051\uff1a\u3055\u3089\u306b\u6761\u4ef6\u3092\u8ffd\u52a0\u3057\u305f\u3044\u3068\u304d\u306f\uff1f<\/h3>\n\n\n\n<p>3\u3064\u4ee5\u4e0a\u306e\u6761\u4ef6\u3092\u8ffd\u52a0\u3057\u305f\u3044\u3068\u304d\u306f\u3069\u3046\u3059\u308b\u306e\u304b\u3092\u793a\u3057\u307e\u3059\u3002<br><br>\u4e0b\u8a18\u306e\u8d64\u67a0\u3067\u56f2\u3063\u305f\u90e8\u5206\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u6301\u3063\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_51.jpg\" alt=\"\" class=\"wp-image-18181\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_51.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_51-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n\n\n\n<p>\u3059\u308b\u3068\u3001\u3053\u3093\u306a\u611f\u3058\u3067\u25b2\u25bc\u30de\u30fc\u30af\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u25bc\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_52.jpg\" alt=\"\" class=\"wp-image-18182\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_52.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_52-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n\n\n\n<p>\u3059\u308b\u3068\u3001\u6761\u4ef6\u7bc4\u56f23\u304c\u8ffd\u52a0\u3055\u308c\u308b\u306e\u3067\u6761\u4ef6\u3092\u5165\u529b\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"388\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_53.jpg\" alt=\"\" class=\"wp-image-18183\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_53.jpg 588w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/tejun_53-300x198.jpg 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n\n\n\n<p>\u6b21\u306e\u7ae0\u3067\u3001SUMIFS\u95a2\u6570\u306e\u5f15\u6570\u306e\u89e3\u8aac\u3092\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading is-style-vk-heading-double_black\">SUMIFS\u95a2\u6570\u306e\u5f15\u6570<\/h2>\n\n\n\n<p>SUMIFS\u95a2\u6570\u306e\u5f15\u6570\u306f\u6b21\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"813\" height=\"139\" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/SUMIFS_hikisu_01.jpg\" alt=\"\" class=\"wp-image-18180\" srcset=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/SUMIFS_hikisu_01.jpg 813w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/SUMIFS_hikisu_01-300x51.jpg 300w, https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2023\/07\/SUMIFS_hikisu_01-768x131.jpg 768w\" sizes=\"auto, (max-width: 813px) 100vw, 813px\" \/><\/figure>\n\n\n\n<p>\u3053\u306e\u5f15\u6570\u306f\u6b21\u306e\u5185\u5bb9\u3092\u793a\u3057\u3066\u3044\u308b\u3093\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-luxe-blocks-border-block\" style=\"margin-top:10px;margin-bottom:30px\"><div class=\"wp-block-luxe-blocks-border-block-content\" style=\"border:3px solid #006edc;border-radius:0px;padding:0px 15px 0px 15px\"><p>\u6761\u4ef6\u7bc4\u56f21\u304c\u6761\u4ef61\u3067\u3001\u6761\u4ef6\u7bc4\u56f22\u304c\u6761\u4ef62\u306b\u5408\u81f4\u3059\u308b\u5408\u8a08\u5bfe\u8c61\u7bc4\u56f2\u306e\u6570\u5024\u3092\u96c6\u8a08\u3059\u308b<\/p><\/div><\/div>\n\n\n\n<p>\u4eca\u56de\u306e\u30d9\u30fc\u30b9\u8868\u3067\u8a00\u3048\u3070\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u306d\u3002<\/p>\n\n\n\n<div class=\"wp-block-luxe-blocks-border-block\" style=\"margin-top:10px;margin-bottom:30px\"><div class=\"wp-block-luxe-blocks-border-block-content\" style=\"border:1px solid #006edc;border-radius:0px;padding:0px 15px 0px 15px\"><p>B2\uff5eB16\uff08\u8cfc\u5165\u7269\u4ef6\uff09\u304cB18\uff08\u98df\u3079\u7269\uff09\u3067\u3001C2\uff5eC16\uff08\u8a73\u7d30\uff09\u304cC18\uff08\u548c\u83d3\u5b50\uff09\u306b\u5408\u81f4\u3059\u308bA2\uff5eA16\uff08\u5024\u6bb5\uff09\u306e\u6570\u5024\u3092\u96c6\u8a08\u3059\u308b<\/p><\/div><\/div>\n\n\n\n<p>\u3055\u3089\u306b\u3001<span data-color=\"#ffff00\" style=\"background: linear-gradient(transparent 60%,rgba(255, 255, 0, 0.7) 0);\" class=\"vk_highlighter\">\u96c6\u8a08\u6761\u4ef6\u3092\u8ffd\u52a0\u3057\u305f\u3051\u308c\u3070\u3001\u6761\u4ef62\u306e\u3042\u3068\u306b\u30ab\u30f3\u30de\u3092\u3064\u3051\u3066\u3001\u300c\u6761\u4ef6\u7bc4\u56f23,\u6761\u4ef63,\u6761\u4ef6\u7bc4\u56f24,\u6761\u4ef64,\uff65\uff65\uff65\u300d\u3092\u66f8\u3044\u3066\u3044\u3051\u3070\u3044\u3044<\/span>\u3093\u3067\u3059\u3002<br><br><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#fe0000\" class=\"has-inline-color\">\u5f15\u6570\u306e\u610f\u5473\u304c\u5206\u304b\u308c\u3070\u3001\u76f4\u63a5\u5185\u5bb9\u3092\u6253\u3061\u8fbc\u3081\u3067\u3082\u540c\u3058\u7d50\u679c\u3092\u51fa\u3059\u3053\u3068\u304c\u51fa\u6765\u307e\u3059<\/mark><\/strong>\u3088\uff01<\/p>\n\n\n\n<!-- WP QUADS v. 2.0.98  Shortcode Ad -->\n<div class=\"quads-location quads-ad\" id=\"quads-ad\" style=\"float:none;margin:0px 0 0px 0;text-align:center;\">\n\u30b9\u30dd\u30f3\u30b5\u30fc\u30ea\u30f3\u30af\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1169427325398969\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- www_\u8a18\u4e8b\u4e2d\uff13 -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-1169427325398969\"\r\n     data-ad-slot=\"8208817721\"\r\n     data-ad-format=\"rectangle\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><br><\/div>\n\n\n\n\n<p>SUMIFS\u95a2\u6570\u306f\u3001\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u3092\u6e80\u305f\u3059\u6570\u5024\u306e\u5408\u8a08\u3092\u8a08\u7b97\u3067\u304d\u307e\u3059\u3002\u3057\u304b\u3082\uff64\u8907\u6570\u6761\u4ef6\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u304c\u3001COUNTIF\u95a2\u6570\u306f\u3001\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u3092\u6e80\u305f\u3059\u500b\u6570\u3092\u6c42\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"blogcard\"><a href=\"https:\/\/www.mizutan.com\/wordpress\/?p=22574\" target=\"_blank\" rel=\"noopener noreferrer\" data-blogcard=\"1\">SUMIFS<\/a><\/div>\n\n\n\n<p>\u203b60\u723a\u306e\u4f5c\u6210\u3057\u305f\u30a8\u30af\u30bb\u30eb\u306e\u8a18\u4e8b\u306b\u3064\u3044\u3066\u3001\u5168\u90e8\u307e\u3068\u3081\u305f\u8a18\u4e8b\u3092\u8ffd\u52a0\u3057\u307e\u3057\u305f\u3002\u5f79\u306b\u7acb\u3064\u5185\u5bb9\u304c\u6e80\u8f09\u3067\u3059\u306e\u3067\u3001\u3061\u3087\u3063\u3068\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"blogcard\"><a href=\"https:\/\/www.mizutan.com\/wordpress\/?p=26518\" target=\"_blank\" rel=\"noopener noreferrer\" data-blogcard=\"1\">\u30a8\u30af\u30bb\u30eb \u3067\u304d\u306a\u3044<\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading is-style-vk-heading-double_black\">\u6700\u5f8c\u306b<\/h2>\n\n\n\n<p>\u30a8\u30af\u30bb\u30eb\u3067\u9805\u76ee\u3054\u3068\u306e\u96c6\u8a08\u3092\u8907\u6570\u6761\u4ef6\u3092\u4ed8\u52a0\u3057\u3066\u5b9f\u65bd\u3059\u308b\u306e\u306b\u4f7f\u3046\u95a2\u6570\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u307e\u3057\u305f\u3002<br><br>\u95a2\u6570\u540d\u306fSUMIFS\u95a2\u6570\u3067\u3059\u3002<br><br>\u3053\u306e\u95a2\u6570\u3092\u4f7f\u3046\u3068\u3001\u9805\u76ee\u3054\u3068\u306e\u96c6\u8a08\u306b\u8907\u6570\u6761\u4ef6\u3092\u4ed8\u52a0\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u308b\u3093\u3067\u3059\u3088\uff01\u4e00\u3064\u306e\u8868\u304c\u3042\u3063\u3066\u3001\u8907\u6570\u6761\u4ef6\u3067\u96c6\u8a08\u3067\u304d\u308b\u306e\u3067\u975e\u5e38\u306b\u5f79\u306b\u7acb\u3061\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-balloon vk_balloon vk_balloon-position-left vk_balloon-type-speech vk_balloon-animation-none\"><div class=\"vk_balloon_icon\"><figure><img decoding=\"async\" class=\"vk_balloon_icon_image vk_balloon_icon_image-type-normal \" src=\"https:\/\/www.mizutan.com\/wordpress\/wp-content\/uploads\/2018\/10\/fukidasi.jpg\" alt=\"\"\/><figcaption class=\"vk_balloon_icon_name\">60\u723a<\/figcaption><\/figure><\/div><div class=\"vk_balloon_content_outer\"><div class=\"vk_balloon_content  \"><span class=\"vk_balloon_content_before \"><\/span><span class=\"vk_balloon_content_after \"><\/span>\n<p>\u6614\u306e\u30a8\u30af\u30bb\u30eb\u3067\u306f\u3001SUMIF\u95a2\u6570\u304c\u3042\u3063\u305f\u3093\u3067\u3059\u304c\u3001\u6761\u4ef6\u304c\u4e00\u3064\u3057\u304b\u6307\u5b9a\u3067\u304d\u306a\u304b\u3063\u305f\u306e\u3067\u4e0d\u6e80\u304c\u3042\u308a\u307e\u3057\u305f\u3002<\/p>\n<\/div><\/div><\/div>\n\n\n\n<p>\u4eca\u56de\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u3055\u308c\u3066\u3044\u308b\u306e\u304c\u308f\u304b\u308a\u611f\u6fc0\u3057\u307e\u3057\u305f\u3002<br><br>\u3084\u308a\u65b9\u3082\u3001\u76f4\u63a5\u66f8\u304f\u306e\u3067\u306f\u306a\u304f\u3001\u30a6\u30a3\u30b6\u30fc\u30c9\u5f62\u5f0f\u3067\u5165\u529b\u3067\u304d\u308b\u306e\u3082\u3046\u308c\u3057\u3044\u3067\u3059\u306d\u3002\u3053\u306e\u8a18\u4e8b\u3092\u898b\u306a\u304c\u3089\u624b\u9806\u3092\u899a\u3048\u3066\u3044\u305f\u3060\u3051\u308c\u3070\u5e78\u3044\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u25a0\u8ffd\u8a18\uff1a\u30a8\u30af\u30bb\u30eb\u3092\u30c6\u30fc\u30de\u306b\u8a18\u4e8b\u3092\u3044\u304f\u3064\u304b\u66f8\u3044\u3066\u3044\u307e\u3059<\/p>\n\n\n\n<div class=\"blogcard\"><a href=\"https:\/\/www.mizutan.com\/wordpress\/?cat=320\" data-blogcard=\"1\">\u30a8\u30af\u30bb\u30eb\u3000\u30d6\u30ed\u30b0\u30ab\u30fc\u30c9<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u30a8\u30af\u30bb\u30eb\u306f\u96c6\u8a08\u3092\u53d6\u308b\u306e\u304c\u51c4\u304f\u7c21\u5358\u3067\u3059\u3088\u306d\u3002\u5358\u7d14\u96c6\u8a08\u306a\u3089SUM\u95a2\u6570\u3067\u4e00\u767a\u3067\u3059\u3002 \u3053\u306e\u96c6\u8a08\u3092\u53d6\u308b\u306e\u306b\u6761\u4ef6\u3092\u4ed8\u52a0\u3057\u3066\u5b9f\u65bd\u3059\u308b\u65b9\u6cd5\u3092\u3054\u5b58\u77e5\u3067\u3059\u304b\u3002 \u4e00\u3064\u306e\u6761\u4ef6\u3092\u4ed8\u52a0\u3057\u3066\u5408\u8a08\u3092\u53d6\u308b\u95a2\u6570\u306a\u3089\u77e5\u3063\u3066\u3044\u307e\u3059\u3002SUMIF\u95a2\u6570\u3067\u3059\u306d\u3002 \u305d\u3046 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":18179,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[],"class_list":["post-18151","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/www.mizutan.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/18151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mizutan.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mizutan.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mizutan.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mizutan.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18151"}],"version-history":[{"count":9,"href":"https:\/\/www.mizutan.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/18151\/revisions"}],"predecessor-version":[{"id":26538,"href":"https:\/\/www.mizutan.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/18151\/revisions\/26538"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mizutan.com\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/18179"}],"wp:attachment":[{"href":"https:\/\/www.mizutan.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mizutan.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mizutan.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}