{"id":2825,"date":"2021-02-11T19:52:14","date_gmt":"2021-02-11T10:52:14","guid":{"rendered":"https:\/\/auto-worker.com\/blog\/?p=2825"},"modified":"2021-02-11T19:52:14","modified_gmt":"2021-02-11T10:52:14","slug":"post-2825","status":"publish","type":"post","link":"https:\/\/auto-worker.com\/blog\/?p=2825","title":{"rendered":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eIF\u3001SUMIF\u3001COUNTIF\u3067\u300c\u542b\u3080(\u90e8\u5206\u4e00\u81f4)\u300d\u3092\u6761\u4ef6\u5224\u5b9a\u3059\u308b"},"content":{"rendered":"<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eIF\u3084SUMIF\u3001COUNTIF\u306f\u901a\u5e38\u3001\u6761\u4ef6\u306b\u5b8c\u5168\u4e00\u81f4\u3059\u308b\u304b\u6761\u4ef6\u5224\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001if\u3067\u90e8\u5206\u4e00\u81f4(\u25cb\u25cb\u3092\u542b\u3080)\u3067\u5224\u5b9a\u3057\u305f\u3044\u5834\u5408\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u305d\u3053\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eif\u7cfb\u306e\u95a2\u6570\u3067\u90e8\u5206\u4e00\u81f4\u306e\u6761\u4ef6\u5224\u5b9a\u3059\u308b\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n<h2>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eif\u306e\u6587\u5b57\u5217\u5224\u5b9a\u306f\u5b8c\u5168\u4e00\u81f4<\/h2>\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u306f\u3001IF\u95a2\u6570\u304c\u3088\u304f\u7528\u3044\u3089\u308c\u307e\u3059\u3002<\/p>\n<p>IF\u95a2\u6570\u306e\u6761\u4ef6\u5224\u5b9a\u306b\u5fdc\u3058\u3066\u3001\u8868\u793a\u3059\u308b\u5185\u5bb9\u3092\u5207\u308a\u66ff\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u305d\u306e\u307b\u304b\u306b\u3082\u3001\u6307\u5b9a\u7bc4\u56f2\u306e\u30bb\u30eb\u3067\u6761\u4ef6\u5224\u5b9a\u3092\u307f\u305f\u3057\u305f\u30bb\u30eb\u3092\u6570\u3048\u308bCOUNTIF\u3084\u3001\u6761\u4ef6\u306b\u4e00\u81f4\u3059\u308b\u30bb\u30eb\u306e\u5024\u3092\u5408\u8a08\u3059\u308bSUMIF\u306a\u3069\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>IF\u95a2\u6570\u3067\u6570\u5024\u3092\u5224\u5b9a\u3059\u308b\u5834\u5408\u306b\u306f\u7b49\u3057\u3044\u4ee5\u5916\u306b\u3001\u300c\u3088\u308a\u5927\u304d\u3044\u300d\u3001\u300c\u3088\u308a\u5c0f\u3055\u3044\u300d\u306a\u3069\u306e\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001IF\u95a2\u6570\u3067\u6587\u5b57\u5217\u3092\u5224\u5b9a\u3059\u308b\u5834\u5408\u3001\u57fa\u672c\u306f\u5b8c\u5168\u4e00\u81f4\u3067\u3059\u3002<\/p>\n<p>\u5224\u5b9a\u6761\u4ef6\u306b\u300c\u5b8c\u5168\u306b\u4e00\u81f4\u300d\u3059\u308b\u304b\u300c\u4e00\u81f4\u3057\u306a\u3044\u304b\u300d\u306e\uff12\u30d1\u30bf\u30fc\u30f3\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<h2>SUMIF\u3084COUNTIF\u3067\u300c\u542b\u3080\u300d\u3092\u5224\u5b9a\u3057\u305f\u3044\u30b1\u30fc\u30b9\u3082<\/h2>\n<p>\u3057\u304b\u3057\u3001IF\u95a2\u6570\u3067\u3082\u5b8c\u5168\u4e00\u81f4\u4ee5\u5916\u306b\u3001\u300c\u542b\u3080\u300d\u3068\u3044\u3063\u305f\u90e8\u5206\u4e00\u81f4\u306e\u5224\u5b9a\u3092\u884c\u3044\u305f\u3044\u30b1\u30fc\u30b9\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u3001\u4f4f\u6240\u306a\u3069\u306e\u5224\u5b9a\u306e\u5834\u5408\u3001\u90fd\u9053\u5e9c\u770c\u3067\u306f\u306a\u304f\u533a\u30fb\u5e02\u753a\u6751\u3067\u5224\u5b9a\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u90e8\u5206\u4e00\u81f4\u304c\u5fc5\u8981\u306b\u306a\u3063\u3066\u304d\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2850\" src=\"https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_001.jpg\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u4f4f\u6240\u306e\u90fd\u9053\u5e9c\u770c\u3084\u5e02\u753a\u6751\u306e\u307f\u3067\u62bd\u51fa\u3057\u305f\u3044\u5834\u5408\u306b\u3001\u300c\u542b\u3080\u300d\u306e\u90e8\u5206\u4e00\u81f4\u306e\u6761\u4ef6\u5224\u5b9a\u304c\u5fc5\u8981\" width=\"800\" height=\"401\" srcset=\"https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_001.jpg 800w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_001-300x150.jpg 300w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_001-768x385.jpg 768w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_001-530x266.jpg 530w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_001-565x283.jpg 565w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_001-710x356.jpg 710w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_001-725x363.jpg 725w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>\u4e0a\u8a18\u306e\u3088\u3046\u306a\u30b1\u30fc\u30b9\u3067\u4f4f\u6240\u304c\u90fd\u9053\u5e9c\u770c\u3068\u533a\u5e02\u753a\u6751\u306e\u5834\u5408\u306b\u3001\u90fd\u9053\u5e9c\u770c\u3054\u3068\u306e\u58f2\u4e0a\u3092SUMIF\u3067\u51fa\u3057\u305f\u3044\u5834\u5408\u306b\u3001\u305d\u306e\u307e\u307e\u90fd\u9053\u5e9c\u770c\u3092\u6307\u5b9a\u3057\u3066\u3082\u5b8c\u5168\u4e00\u81f4\u3067\u306f\u306a\u3044\u305f\u3081\u3001\u7b97\u51fa\u4e0d\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<p>\u305f\u3060\u3001\u5b9f\u306fIF\u95a2\u6570\u306e\u6761\u4ef6\u306e\u5f15\u6570\u3092\u5de5\u592b\u3059\u308b\u3053\u3068\u3067\u3001\u90e8\u5206\u4e00\u81f4\u3067\u306e\u5224\u5b9a\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<h2>if,sumif,countif\u3067\u90e8\u5206\u4e00\u81f4(\u542b\u3080)\u3067\u5224\u5b9a\u3059\u308b\u65b9\u6cd5<\/h2>\n<p>\u305d\u3053\u3067\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eIF\u3084COUNTIF\u3001SUMIF\u3067\u5b8c\u5168\u4e00\u81f4\u3067\u306f\u306a\u304f\u90e8\u5206\u4e00\u81f4\u306e\u6761\u4ef6\u3067\u5224\u5b9a\u3059\u308b\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n<p>IF\u7cfb\u306e\u95a2\u6570\u3067\u90e8\u5206\u4e00\u81f4\u306e\u5224\u5b9a\u3092\u884c\u3046\u30b1\u30fc\u30b9\u3068\u3057\u3066\u3001\u4ee5\u4e0b\u306e2\u7a2e\u985e\u306e\u65b9\u6cd5\u3092\u305d\u308c\u305e\u308c\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<ol>\n<li>\u6587\u5b57\u5217\u3092\u542b\u3080\u304b\u306e\u6761\u4ef6\u5224\u5b9a<\/li>\n<li>\u30bb\u30eb\u53c2\u7167\u306b\u3088\u308b\u90e8\u5206\u4e00\u81f4\u306e\u6761\u4ef6\u5224\u5b9a<\/li>\n<\/ol>\n<h3>\u6587\u5b57\u5217\u3092\u542b\u3080\u304b\u3001\u90e8\u5206\u4e00\u81f4\u3092\u5224\u5b9a\u3059\u308b\u65b9\u6cd5<\/h3>\n<p>IF\u3084COUNTIF\u3001SUMIF\u3067\u6307\u5b9a\u7bc4\u56f2\u3067\u6587\u5b57\u5217\u3092\u542b\u3093\u3067\u3044\u308b\u304b\u3001\u90e8\u5206\u4e00\u81f4\u306e\u6761\u4ef6\u5224\u5b9a\u3092\u884c\u3046\u65b9\u6cd5\u306f\u3001\u300c&#8221;*(\u5224\u5b9a\u6587\u5b57\u5217)*&#8221;\u300d\u3092\u6761\u4ef6\u306e\u5f15\u6570\u306b\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u3001\u5148\u7a0b\u7d39\u4ecb\u3057\u305f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067COUNTIF\u95a2\u6570\u3092\u4f7f\u3044\u3001\u300c\u6e2f\u533a\u300d\u3092\u542b\u3093\u3067\u3044\u308b\u884c\u3092\u30ab\u30a6\u30f3\u30c8\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2851\" src=\"https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_002.jpg\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eCOUNTIF\u3067\u6e2f\u533a\u3092\u542b\u3080\u304b\u90e8\u5206\u4e00\u81f4\u3092\u6e80\u305f\u3057\u305f\u884c\u6570\u3092\u30ab\u30a6\u30f3\u30c8\" width=\"1200\" height=\"614\" srcset=\"https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_002.jpg 1200w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_002-300x154.jpg 300w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_002-768x393.jpg 768w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_002-1024x524.jpg 1024w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_002-530x271.jpg 530w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_002-565x289.jpg 565w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_002-710x363.jpg 710w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_002-725x371.jpg 725w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p><em><strong>=COUNTIF(F2:F16,&#8221;*\u6e2f\u533a*&#8221;)<\/strong><\/em><\/p>\n<p>\u7d50\u679c\u3001COUNTIF\u95a2\u6570\u304c\u6e2f\u533a\u304c\u542b\u307e\u308c\u3066\u3044\u308b2\u3064\u306e\u30bb\u30eb\u3092\u691c\u51fa\u3057\u30012\u3068\u51fa\u529b\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n<p>\u7d9a\u3044\u3066\u3001SUMIF\u95a2\u6570\u3067\u3082\u540c\u69d8\u306bF\u5217\u306e\u4f4f\u6240\u304c\u300c\u5927\u962a\u300d\u3067\u3042\u308b\u6ce8\u6587\u91d1\u984d\u3092\u5408\u8a08\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2852\" src=\"https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_003.jpg\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eSUMIF\u95a2\u6570\u3067\u90e8\u5206\u4e00\u81f4\u3092\u6e80\u305f\u3057\u305f\u30bb\u30eb\u306e\u5408\u8a08\u5024\u3092\u7b97\u51fa\" width=\"1200\" height=\"615\" srcset=\"https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_003.jpg 1200w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_003-300x154.jpg 300w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_003-768x394.jpg 768w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_003-1024x525.jpg 1024w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_003-530x272.jpg 530w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_003-565x290.jpg 565w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_003-710x364.jpg 710w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_003-725x372.jpg 725w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p><em><strong>=SUMIF(F2:F16, &#8220;*\u5927\u962a*&#8221;, E2:E16)<\/strong><\/em><\/p>\n<p>SUMIF\u95a2\u6570\u306e2\u756a\u76ee\u306e\u5f15\u6570\u3001\u6761\u4ef6\u3092*(\u30a2\u30b9\u30bf\u30ea\u30b9\u30af)\u3067\u631f\u3080\u3053\u3068\u3067\u5927\u962a\u304c\u542b\u307e\u308c\u3066\u3044\u308b3\u3064\u306e\u30bb\u30eb\u3092\u691c\u51fa\u3057\u3001E\u5217\u306e\u6ce8\u6587\u91d1\u984d\u3092\u5408\u8a08\u3057\u30013500\u3092\u51fa\u529b\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n<p>\u203b\u3053\u306e\u90e8\u5206\u4e00\u81f4\u306e\u5224\u5b9a\u65b9\u6cd5\u306fIF\u95a2\u6570\u3067\u3082\u9069\u7528\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<h3>\u30bb\u30eb\u53c2\u7167\u306b\u3088\u308b\u90e8\u5206\u4e00\u81f4\u306e\u6761\u4ef6\u5224\u5b9a<\/h3>\n<p>\u6b21\u306f\u30bb\u30eb\u53c2\u7167\u3092\u7528\u3044\u305f\u90e8\u5206\u4e00\u81f4\u306e\u6761\u4ef6\u5224\u5b9a\u3092IF\u3084SUMIF\u3001COUNTIF\u3067\u8868\u73fe\u3059\u308b\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n<p>\u6ce8\u6587\u306e\u4f4f\u6240\u3067G\u5217\u306b\u8a2d\u5b9a\u3055\u308c\u305f\u6771\u4eac\u3068\u5927\u962a\u3092\u542b\u3093\u3067\u3044\u308b\u6ce8\u6587\u306e\u91d1\u984d\u3092SUMIF\u3067\u6761\u4ef6\u5224\u5b9a\u3057\u3001\u5408\u8a08\u3057\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2854\" src=\"https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_004.jpg\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eIF\u3084SUMIF\u3001COUNTIF\u3067\u30bb\u30eb\u53c2\u7167\u3067\u90e8\u5206\u4e00\u81f4\u3092\u6761\u4ef6\u5224\u5b9a\u3059\u308b\" width=\"1200\" height=\"615\" srcset=\"https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_004.jpg 1200w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_004-300x154.jpg 300w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_004-768x394.jpg 768w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_004-1024x525.jpg 1024w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_004-530x272.jpg 530w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_004-565x290.jpg 565w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_004-710x364.jpg 710w, https:\/\/auto-worker.com\/blog\/wp-content\/uploads\/2021\/02\/20210210_auto_004-725x372.jpg 725w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p><em><strong>=SUMIF(F2:F16, &#8220;*&#8221;&amp;G4&amp;&#8221;*&#8221;, E2:E16)<\/strong><\/em><\/p>\n<p>*(\u30a2\u30b9\u30bf\u30ea\u30b9\u30af)\u3068\u30bb\u30eb\u53c2\u7167\u3092\u7d50\u5408\u3059\u308b\u3053\u3068\u3067\u3001\u30bb\u30eb\u53c2\u7167\u3057\u305f\u60c5\u5831\u3092\u542b\u3093\u3067\u3044\u308b\u4f4f\u6240\u3092\u691c\u51fa\u3057\u3001\u91d1\u984d\u3092SUMIF\u3067\u5408\u8a08\u3057\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u3088\u3046\u306b\u6587\u5b57\u5217\u306e\u5834\u5408\u3068\u30bb\u30eb\u53c2\u7167\u3067\u3082IF\u3084SUMIF\u3001COUNTIF\u3067\u90e8\u5206\u4e00\u81f4\u306e\u6761\u4ef6\u5224\u5b9a\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<h2>\u5fdc\u7528\u3067\u524d\u65b9\u4e00\u81f4\u3084\u5f8c\u65b9\u4e00\u81f4\u306eif\u5224\u5b9a\u3082<\/h2>\n<p>IF\u3084SUMIF\u3001COUNTIF\u95a2\u6570\u3067\u90e8\u5206\u4e00\u81f4\u306e\u5224\u5b9a\u3092\u884c\u3046\u5834\u5408\u306b\u306f\u3001&#8221;*(\u5224\u5b9a\u6587\u5b57\u5217)*&#8221;\u3068\u3044\u3046\u8a18\u8ff0\u3092\u884c\u3046\u3053\u3068\u3067\u3001\u5224\u5b9a\u6587\u5b57\u5217\u3092\u542b\u3080\u304b\u306e\u6761\u4ef6\u5206\u5c90\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<p>\u3055\u3089\u306b\u3001\u3053\u306e\u90e8\u5206\u4e00\u81f4\u3092\u5fdc\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u524d\u65b9\u4e00\u81f4\u3084\u5f8c\u65b9\u4e00\u81f4\u3082IF\u3067\u8868\u73fe\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u524d\u306b\u3042\u308b1\u3064\u76ee\u306e*(\u30a2\u30b9\u30bf\u30ea\u30b9\u30af)\u3092\u53d6\u308a\u9664\u304f\u3053\u3068\u3067\u524d\u65b9\u4e00\u81f4\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><strong>IF\u95a2\u6570\u3067&#8221;(\u5224\u5b9a\u6587\u5b57\u5217)*&#8221;\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3067\u300c\u5224\u5b9a\u6587\u5b57\u5217\u304b\u3089\u59cb\u307e\u308b\u300d\u3068\u3044\u3046\u5224\u5b9a\u304c\u53ef\u80fd<\/strong>\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u307e\u305f\u3001\u5f8c\u308d\u306b\u3042\u308b2\u3064\u76ee\u306e*\u3092\u53d6\u308a\u9664\u304f\u3068\u3001\u6b21\u306f\u5f8c\u65b9\u4e00\u81f4\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><strong>&#8220;*(\u5224\u5b9a\u6587\u5b57\u5217)&#8221;\u3067\u300c\u5224\u5b9a\u6587\u5b57\u5217\u3067\u7d42\u308f\u308b\u300d\u3068\u3044\u3046\u5f8c\u65b9\u4e00\u81f4\u306e\u5224\u5b9a\u304c\u3067\u304d\u307e\u3059<\/strong>\u3002<\/p>\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eIF\u95a2\u6570\u5468\u308a\u3067\u306f\u300c*\u300d\u3092\u4f7f\u3044\u3053\u306a\u3059\u3053\u3068\u3067\u3001\u90e8\u5206\u4e00\u81f4\u306b\u52a0\u3048\u3001\u524d\u65b9\u4e00\u81f4\u3084\u5f8c\u65b9\u4e00\u81f4\u306e\u5224\u5b9a\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<h2>\u307e\u3068\u3081\u30fb\u7d42\u308f\u308a\u306b<\/h2>\n<p>\u4eca\u56de\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eIF\u3084SUMIF\u3001COUNTIF\u3067\u90e8\u5206\u4e00\u81f4\u3067\u6587\u5b57\u5217\u3092\u6761\u4ef6\u5224\u5b9a\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u901a\u5e38\u306eIF\u95a2\u6570\u3067\u306f\u3001\u6587\u5b57\u5217\u306e\u5224\u5b9a\u306f\u5b8c\u5168\u4e00\u81f4\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001SUMIF\u3084COUNTIF\u306a\u3069\u3067\u6587\u5b57\u5217\u304c\u542b\u307e\u308c\u308b\u3068\u3044\u3046\u90e8\u5206\u4e00\u81f4\u306e\u5224\u5b9a\u3092\u884c\u3044\u305f\u3044\u30b1\u30fc\u30b9\u306f\u591a\u3044\u3067\u3059\u3002<\/p>\n<p>\u305d\u306e\u5834\u5408\u306fIF\u95a2\u6570\u306e\u8ad6\u7406\u5f0f\u306b\u300c*(\u6761\u4ef6\u306e\u6587\u5b57\u5217)*\u300d\u3068\u8a18\u8ff0\u3059\u308b\u3053\u3068\u3067\u90e8\u5206\u4e00\u81f4\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<p>\u3055\u3089\u306b\u3001\u524d\u306e*(\u30a2\u30b9\u30bf\u30ea\u30b9\u30af)\u3092\u53d6\u308a\u9664\u3051\u3070\u524d\u65b9\u4e00\u81f4\u3001\u5f8c\u308d\u306e*\u3092\u53d6\u308a\u9664\u3051\u3070\u5f8c\u65b9\u4e00\u81f4\u306e\u5224\u5b9a\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>SUMIF\u3084COUNTIF\u3067\u4e00\u90e8\u306e\u6587\u5b57\u5217\u3092\u542b\u3093\u3067\u3044\u308b\u304b\u3068\u3044\u3046\u6761\u4ef6\u5224\u5b9a\u3092\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u4eca\u56de\u306e\u65b9\u6cd5\u3092\u6d3b\u7528\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eIF\u3084SUMIF\u3001COUNTIF\u306f\u901a\u5e38\u3001\u6761\u4ef6\u306b\u5b8c\u5168\u4e00\u81f4\u3059\u308b\u304b\u6761\u4ef6\u5224\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002 \u3057\u304b\u3057\u3001if\u3067\u90e8\u5206\u4e00\u81f4(\u25cb\u25cb\u3092\u542b\u3080)\u3067\u5224\u5b9a\u3057\u305f\u3044\u5834\u5408\u3082\u3042\u308a\u307e\u3059\u3002 \u305d\u3053\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eif\u7cfb\u306e\u95a2\u6570\u3067\u90e8\u5206\u4e00\u81f4\u306e\u6761\u4ef6\u5224 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2852,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[260,64,567,542],"class_list":["post-2825","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-if","tag-64","tag-567","tag-542"],"_links":{"self":[{"href":"https:\/\/auto-worker.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/auto-worker.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/auto-worker.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/auto-worker.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/auto-worker.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2825"}],"version-history":[{"count":6,"href":"https:\/\/auto-worker.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2825\/revisions"}],"predecessor-version":[{"id":2856,"href":"https:\/\/auto-worker.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2825\/revisions\/2856"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/auto-worker.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/2852"}],"wp:attachment":[{"href":"https:\/\/auto-worker.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/auto-worker.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/auto-worker.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}