{"id":2097,"date":"2024-01-21T14:54:19","date_gmt":"2024-01-21T05:54:19","guid":{"rendered":"https:\/\/amadoc-insight.com\/?p=2097"},"modified":"2025-03-30T23:27:25","modified_gmt":"2025-03-30T14:27:25","slug":"%e6%9d%a1%e4%bb%b6%e3%81%ab%e5%90%88%e8%87%b4%e3%81%99%e3%82%8b%e3%83%87%e3%83%bc%e3%82%bf%e3%81%ae%e5%b9%b3%e5%9d%87-%e7%a9%ba%e7%99%bd%e3%82%840%e3%82%92%e9%99%a4%e5%a4%96%e3%81%97%e3%81%a6%e5%b9%b3","status":"publish","type":"post","link":"https:\/\/amadoc-insight.com\/?p=2097","title":{"rendered":"\u3010Excel\u3011\u6761\u4ef6\u306b\u5408\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u306e\u5e73\u5747\/\u7a7a\u767d\u30840\u3092\u9664\u5916\u3057\u3066\u5e73\u5747\u3092\u51fa\u3059\u3000\uff0dAVERAGEIF\u3001AVERAGEIFS\u95a2\u6570"},"content":{"rendered":"\n<div class=\"wp-block-columns\">\n<div class=\"wp-block-column\">\n<figure class=\"wp-block-image size-large is-resized is-style-border\"><a href=\"https:\/\/www.amazon.co.jp\/dp\/B0F2LTMYGL\"><img decoding=\"async\" width=\"709\" height=\"1024\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u3010\u8868\u7d19\u3011\u30b3\u30f3\u30b5\u30eb\u6d41\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u30c6\u30af\u30cb\u30c3\u30af\u3000\uff5e\u3053\u308cExcel\u3067\u3069\u3046\u3084\u308b\u3093\u3060\u3063\u3051\uff1f\uff5e-709x1024.jpg\" alt=\"\" class=\"wp-image-6008\" style=\"width:200px\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u3010\u8868\u7d19\u3011\u30b3\u30f3\u30b5\u30eb\u6d41\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u30c6\u30af\u30cb\u30c3\u30af\u3000\uff5e\u3053\u308cExcel\u3067\u3069\u3046\u3084\u308b\u3093\u3060\u3063\u3051\uff1f\uff5e-709x1024.jpg 709w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u3010\u8868\u7d19\u3011\u30b3\u30f3\u30b5\u30eb\u6d41\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u30c6\u30af\u30cb\u30c3\u30af\u3000\uff5e\u3053\u308cExcel\u3067\u3069\u3046\u3084\u308b\u3093\u3060\u3063\u3051\uff1f\uff5e-208x300.jpg 208w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u3010\u8868\u7d19\u3011\u30b3\u30f3\u30b5\u30eb\u6d41\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u30c6\u30af\u30cb\u30c3\u30af\u3000\uff5e\u3053\u308cExcel\u3067\u3069\u3046\u3084\u308b\u3093\u3060\u3063\u3051\uff1f\uff5e.jpg 720w\" sizes=\"(max-width: 709px) 100vw, 709px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><a href=\"https:\/\/www.amazon.co.jp\/dp\/B0F2LTMYGL\"><strong>2025\u5e74\u7248\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u65b0\u6a5f\u80fd\u30fb\u65b0\u95a2\u6570<\/strong><\/a><\/p>\n\n\n\n<p>2021\u5e74\u4ee5\u964d\u3092\u4e2d\u5fc3\u306bExcel\u306b\u8ffd\u52a0\u3055\u308c\u305f\u6a5f\u80fd\u30fb\u95a2\u6570\u306e\u4e2d\u3067\u7279\u306b\u5b9f\u52d9\u306b\u5f79\u7acb\u3064\u3082\u306e\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3084\u4ed6\u306e\u6a5f\u80fd\u30fb\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u305f\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af\u3082\u7d39\u4ecb\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column\">\n<figure class=\"wp-block-image size-large is-resized is-style-border\"><a href=\"https:\/\/www.amazon.co.jp\/dp\/B0DPG4GYWC\"><img decoding=\"async\" width=\"709\" height=\"1024\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u8868\u7d19-709x1024.jpg\" alt=\"\" class=\"wp-image-6009\" style=\"width:200px\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u8868\u7d19-709x1024.jpg 709w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u8868\u7d19-208x300.jpg 208w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u8868\u7d19.jpg 720w\" sizes=\"(max-width: 709px) 100vw, 709px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><strong><a href=\"https:\/\/www.amazon.co.jp\/dp\/B0DPG4GYWC\">\u30b3\u30f3\u30b5\u30eb\u6d41\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u30c6\u30af\u30cb\u30c3\u30af<\/a><\/strong><\/p>\n\n\n\n<p>\u30b3\u30f3\u30b5\u30eb\u30bf\u30f3\u30c8\u3068\u3057\u3066\u69d8\u3005\u306a\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u5f93\u4e8b\u3057\u3066\u304d\u305f\u8457\u8005\u304c\u3001\u5b9f\u52d9\u306b\u304a\u3044\u3066\u5b9f\u969b\u306b\u6d3b\u7528\u3057\u305fExcel\u306e\u30c6\u30af\u30cb\u30c3\u30af\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u8457\u8005\u81ea\u8eab\u304c\u300c\u3042\u308c\uff1f\u3069\u3046\u3059\u308c\u3070\u3044\u3044\u3093\u3060\u308d\u3046\u300d\u3068\u60a9\u3093\u3060\u90e8\u5206\u3092\u4e2d\u5fc3\u306b\u30d4\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-swl-main-color has-alpha-channel-opacity has-swl-main-background-color has-background is-style-wide\"\/>\n\n\n\n<p>Excel\u3067\u6761\u4ef6\u306b\u5408\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u306e\u5e73\u5747\u3092\u51fa\u3057\u305f\u3044\u5834\u5408\u3001AVERAGEIF\/AVERAGEIFS\u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u3067\u306f\u30014\u30d1\u30bf\u30fc\u30f3\u306eAVERAGEIF\/AVERAGEIFS\u3092\u6d3b\u7528\u3057\u305f\u5e73\u5747\u306e\u7b97\u51fa\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>1\u3064\u306e\u6761\u4ef6\u306b\u5408\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u306e\u5e73\u5747\u3092\u51fa\u3059<\/li>\n\n\n\n<li>\u8907\u6570\u306e\u6761\u4ef6\u306b\u5408\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u306e\u5e73\u5747\u3092\u51fa\u3059<\/li>\n\n\n\n<li>\u7a7a\u767d\u3092\u9664\u5916\u3057\u3066\u5e73\u5747\u3092\u51fa\u3059<\/li>\n\n\n\n<li>0\u3092\u9664\u5916\u3057\u3066\u5e73\u5747\u3092\u51fa\u3059<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-jetpack-related-posts\">\n<h2 class=\"wp-block-heading is-style-section_ttl\">\u95a2\u9023\u8a18\u4e8b<\/h2>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">1\u3064\u306e\u6761\u4ef6\u306b\u5408\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u306e\u5e73\u5747\u3092\u51fa\u3059\u3000\uff0dAVERAGEIF<\/h2>\n\n\n\n<p>\u6b21\u306e\u3088\u3046\u306a\u55b6\u696d\u6210\u7e3e\u8868\u304c\u3042\u3063\u305f\u5834\u5408\u3001\u8ab2\u3054\u3068\u306b\u55b6\u696d\u6210\u7e3e\u306e\u5e73\u5747\u3092\u51fa\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-border\"><img decoding=\"async\" width=\"774\" height=\"728\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-17.png\" alt=\"\" class=\"wp-image-2100\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-17.png 774w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-17-300x282.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-17-768x722.png 768w\" sizes=\"(max-width: 774px) 100vw, 774px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u307e\u305a\u3001\u8a08\u7b97\u7528\u306e\u8868\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u55b6\u696d\u6210\u7e3e\u306e\u8868\u3068\u8a08\u7b97\u7528\u306e\u8868\u3067\u3001\u300c\u8ab2\u300d\u306e\u540d\u524d\u304c\u4e00\u81f4\u3057\u3066\u3044\u306a\u3044\u3068\u6b63\u3057\u304f\u8a08\u7b97\u3067\u304d\u306a\u3044\u306e\u3067\u3001\u8868\u8a18\u306b\u8aa4\u308a\u304c\u306a\u3044\u3088\u3046\u306b\u6ce8\u610f\u3057\u307e\u3059\u3002\u55b6\u696d\u6210\u7e3e\u306e\u8868\u304b\u3089\u30b3\u30d4\u30da\u3059\u308b\u306e\u304c\u304a\u3059\u3059\u3081\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"674\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-18-1024x674.png\" alt=\"\" class=\"wp-image-2101\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-18-1024x674.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-18-300x197.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-18-768x505.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-18.png 1208w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u300c\u55b6\u696d\u4e00\u8ab2\u300d\u3067\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u3066\u5e73\u5747\u3092\u8a08\u7b97\u3059\u308b\u5834\u5408\u3001\u30bb\u30ebG4\u306b\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3057\u307e\u3059\u3002AVERAGEIF\u3067\u306f\u3001AVERAGEIF(<strong>\u7bc4\u56f2<\/strong>,<strong>\u6761\u4ef6<\/strong>,<strong>\u5e73\u5747\u5bfe\u8c61\u7bc4\u56f2<\/strong>)\u3092\u8a18\u8ff0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>=AVERAGEIF($C$4:$C$13,F4,$D$4:$D$13)<\/p>\n<\/blockquote>\n\n\n\n<p><strong>\u7bc4\u56f2<\/strong>\u306b\u306f\u3001\u6761\u4ef6\u3092\u691c\u7d22\u3059\u308b\u305f\u3081\u306e\u300c\u8ab2\u300d\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u30bb\u30ebC4~C13\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<span class=\"swl-marker mark_yellow\">\u3053\u3053\u3067\u306f\u3001\u300c\u55b6\u696d\u4e8c\u8ab2\u300d\u300c\u55b6\u696d\u4e09\u8ab2\u300d\u3082\u540c\u69d8\u306b\u5e73\u5747\u3092\u51fa\u3057\u305f\u3044\u306e\u3067\u7d76\u5bfe\u53c2\u7167\u3068\u3057\u307e\u3059\u3002<\/span><\/p>\n\n\n\n<p><strong>\u6761\u4ef6<\/strong>\u306b\u306f\u3001\u6307\u5b9a\u3057\u305f\u3044\u6761\u4ef6\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u30bb\u30ebF4\u3092\u53c2\u7167\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><strong>\u5e73\u5747\u5bfe\u8c61\u7bc4\u56f2<\/strong>\u306b\u306f\u3001\u5e73\u5747\u5024\u3092\u51fa\u3057\u305f\u3044\u6570\u5024\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308bD4~D13\u3092\u53c2\u7167\u3057\u307e\u3059\u3002<span class=\"swl-marker mark_yellow\">\u3053\u3053\u3067\u306f\u3001\u300c\u55b6\u696d\u4e8c\u8ab2\u300d\u300c\u55b6\u696d\u4e09\u8ab2\u300d\u3082\u540c\u69d8\u306b\u5e73\u5747\u3092\u51fa\u3057\u305f\u3044\u306e\u3067\u7d76\u5bfe\u53c2\u7167\u3068\u3057\u307e\u3059\u3002<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"556\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-19-1024x556.png\" alt=\"\" class=\"wp-image-2102\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-19-1024x556.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-19-300x163.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-19-768x417.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-19.png 1450w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>Enter\u30ad\u30fc\u3092\u62bc\u3059\u3068\u300c\u55b6\u696d\u4e00\u8ab2\u300d\u306e\u55b6\u696d\u6210\u7e3e\u306e\u5e73\u5747\u304c\u7b97\u51fa\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"678\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-21-1024x678.png\" alt=\"\" class=\"wp-image-2105\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-21-1024x678.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-21-300x199.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-21-768x509.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-21.png 1208w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3053\u306e\u6570\u5f0f\u3092\u30bb\u30ebG5,G6\u306b\u3082\u30b3\u30d4\u30da\u3059\u308b\u3068\u300c\u55b6\u696d\u4e8c\u8ab2\u300d\u300c\u55b6\u696d\u4e09\u8ab2\u300d\u3082\u540c\u69d8\u306b\u5e73\u5747\u3092\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"673\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-22-1024x673.png\" alt=\"\" class=\"wp-image-2106\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-22-1024x673.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-22-300x197.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-22-768x504.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-22.png 1209w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<script data-jetpack-boost=\"ignore\" async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1873295597469931\"\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-1873295597469931\"\r\n     data-ad-slot=\"5031486087\"><\/ins>\r\n<script data-jetpack-boost=\"ignore\">\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n\n\n\n<h2 class=\"wp-block-heading\">\u8907\u6570\u306e\u6761\u4ef6\u306b\u5408\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u306e\u5e73\u5747\u3092\u51fa\u3059\u3000\uff0dAVERAGEIFS<\/h2>\n\n\n\n<p>\u6b21\u306e\u3088\u3046\u306a\u55b6\u696d\u6210\u7e3e\u8868\u304c\u3042\u3063\u305f\u5834\u5408\u3001\u8ab2\u3068\u53d6\u308a\u6271\u3063\u3066\u3044\u308b\u5546\u54c1\u3054\u3068\u306b\u55b6\u696d\u6210\u7e3e\u306e\u5e73\u5747\u3092\u51fa\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-border\"><img decoding=\"async\" width=\"918\" height=\"794\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-23.png\" alt=\"\" class=\"wp-image-2108\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-23.png 918w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-23-300x259.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-23-768x664.png 768w\" sizes=\"(max-width: 918px) 100vw, 918px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u307e\u305a\u3001\u8a08\u7b97\u7528\u306e\u8868\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u55b6\u696d\u6210\u7e3e\u306e\u8868\u3068\u8a08\u7b97\u7528\u306e\u8868\u3067\u3001\u300c\u8ab2\u300d\u300c\u5546\u54c1\u300d\u306e\u540d\u524d\u304c\u4e00\u81f4\u3057\u3066\u3044\u306a\u3044\u3068\u6b63\u3057\u304f\u8a08\u7b97\u3067\u304d\u306a\u3044\u306e\u3067\u3001\u8868\u8a18\u306b\u8aa4\u308a\u304c\u306a\u3044\u3088\u3046\u306b\u6ce8\u610f\u3057\u307e\u3059\u3002\u55b6\u696d\u6210\u7e3e\u306e\u8868\u304b\u3089\u30b3\u30d4\u30da\u3059\u308b\u306e\u304c\u304a\u3059\u3059\u3081\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"543\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-24-1024x543.png\" alt=\"\" class=\"wp-image-2109\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-24-1024x543.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-24-300x159.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-24-768x407.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-24.png 1496w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u300c\u55b6\u696d\u4e00\u8ab2\u300d\u304b\u3064\u300c\u5546\u54c1A\u300d\u3067\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u3066\u5e73\u5747\u3092\u8a08\u7b97\u3059\u308b\u5834\u5408\u3001\u30bb\u30ebI4\u306b\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3057\u307e\u3059\u3002AVERAGEIFS\u3067\u306f\u3001AVERAGEIFS(\u5e73\u5747\u5bfe\u8c61\u7bc4\u56f2,\u6761\u4ef6\u7bc4\u56f21,\u6761\u4ef61,\u6761\u4ef6\u7bc4\u56f22,\u6761\u4ef62,\u2026)\u3092\u8a18\u8ff0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u3067\u300c\u6761\u4ef61\u304b\u3064\u6761\u4ef62\u300d\u3068\u3044\u3046\u6761\u4ef6\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3092\u610f\u5473\u3057\u307e\u3059\u3002\u6761\u4ef6\u7bc4\u56f2\u3068\u6761\u4ef6\u306f2\u3064\u4ee5\u4e0a\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>=AVERAGEIFS($E$4:$E$13,$C$4:$C$13,G4,$D$4:$D$13,H4)<\/p>\n<\/blockquote>\n\n\n\n<p><strong>\u5e73\u5747\u5bfe\u8c61\u7bc4\u56f2<\/strong>\u306b\u306f\u3001\u5e73\u5747\u5024\u3092\u51fa\u3057\u305f\u3044\u6570\u5024\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308bE4~E13\u3092\u53c2\u7167\u3057\u307e\u3059\u3002AVERAGEIF\u3068\u306f\u9055\u3063\u3066\u3001\u6700\u521d\u306b\u5e73\u5747\u5bfe\u8c61\u7bc4\u56f2\u3092\u9078\u629e\u3059\u308b\u306e\u3067\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<span class=\"swl-marker mark_yellow\">\u3053\u3053\u3067\u306f\u3001\u4ed6\u306e\u7d44\u307f\u5408\u308f\u305b\u3082\u540c\u69d8\u306b\u5e73\u5747\u3092\u51fa\u3057\u305f\u3044\u306e\u3067\u7d76\u5bfe\u53c2\u7167\u3068\u3057\u307e\u3059\u3002<\/span><\/p>\n\n\n\n<p><strong>\u6761\u4ef6\u7bc4\u56f21<\/strong>\u306b\u306f\u3001\u6761\u4ef6\u3092\u691c\u7d22\u3059\u308b\u305f\u3081\u306e\u300c\u8ab2\u300d\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u30bb\u30ebC4~C13\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<span class=\"swl-marker mark_yellow\">\u3053\u3053\u3067\u306f\u3001\u300c\u55b6\u696d\u4e8c\u8ab2\u300d\u300c\u55b6\u696d\u4e09\u8ab2\u300d\u3082\u540c\u69d8\u306b\u5e73\u5747\u3092\u51fa\u3057\u305f\u3044\u306e\u3067\u7d76\u5bfe\u53c2\u7167\u3068\u3057\u307e\u3059\u3002<\/span>\u305d\u3057\u3066\u3001<strong>\u6761\u4ef61<\/strong>\u306b\u306f\u3001\u6307\u5b9a\u3057\u305f\u3044\u6761\u4ef6\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u30bb\u30ebG4\u3092\u53c2\u7167\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u540c\u69d8\u306b<strong>\u6761\u4ef6\u7bc4\u56f22<\/strong>\u306b\u306f\u3001\u6761\u4ef6\u3092\u691c\u7d22\u3059\u308b\u305f\u3081\u306e\u300c\u5546\u54c1\u300d\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u30bb\u30ebD4~D13\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<span class=\"swl-marker mark_yellow\">\u3053\u3053\u3067\u306f\u3001\u300c\u5546\u54c1B\u300d\u3082\u540c\u69d8\u306b\u5e73\u5747\u3092\u51fa\u3057\u305f\u3044\u306e\u3067\u7d76\u5bfe\u53c2\u7167\u3068\u3057\u307e\u3059\u3002<\/span>\u305d\u3057\u3066\u3001<strong>\u6761\u4ef62<\/strong>\u306b\u306f\u3001\u6307\u5b9a\u3057\u305f\u3044\u6761\u4ef6\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u30bb\u30ebH4\u3092\u53c2\u7167\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"509\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-26-1024x509.png\" alt=\"\" class=\"wp-image-2111\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-26-1024x509.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-26-300x149.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-26-768x382.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-26-1536x764.png 1536w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-26.png 1632w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>Enter\u30ad\u30fc\u3092\u62bc\u3059\u3068\u3001\u300c\u55b6\u696d\u4e00\u8ab2\u300d\u304b\u3064\u300c\u5546\u54c1A\u300d\u3092\u6271\u3046\u4eba\u306e\u55b6\u696d\u6210\u7e3e\u306e\u5e73\u5747\u304c\u8a08\u7b97\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"548\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-27-1024x548.png\" alt=\"\" class=\"wp-image-2112\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-27-1024x548.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-27-300x160.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-27-768x411.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-27.png 1496w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3053\u306e\u6570\u5f0f\u3092\u30bb\u30ebI5~I9\u306b\u30b3\u30d4\u30da\u3059\u308b\u3068\u3001\u4ed6\u306e\u7d44\u307f\u5408\u308f\u305b\u3082\u540c\u69d8\u306b\u5e73\u5747\u304c\u8a08\u7b97\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"546\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-28-1024x546.png\" alt=\"\" class=\"wp-image-2113\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-28-1024x546.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-28-300x160.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-28-768x409.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-28.png 1497w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<script data-jetpack-boost=\"ignore\" async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1873295597469931\"\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-1873295597469931\"\r\n     data-ad-slot=\"5031486087\"><\/ins>\r\n<script data-jetpack-boost=\"ignore\">\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n\n\n\n<h2 class=\"wp-block-heading\">\u7a7a\u767d\u3092\u9664\u5916\u3057\u3066\u5e73\u5747\u3092\u51fa\u3059<\/h2>\n\n\n\n<p>\u6b21\u306b\u7a7a\u767d\u3092\u9664\u5916\u3057\u3066\u5e73\u5747\u3092\u8a08\u7b97\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><span class=\"swl-marker mark_orange\">\u5b9f\u306f\u3001\u7a7a\u767d\u3092\u9664\u5916\u3059\u308b\u5834\u5408\u3001\u7279\u306b\u64cd\u4f5c\u306f\u5fc5\u8981\u3042\u308a\u307e\u305b\u3093<\/span>\u3002AVERAGEIF\/AVERAGEIFS\u3067\u306f\u3001\u7a7a\u767d\u306f\u81ea\u52d5\u7684\u306b\u9664\u5916\u3057\u3066\u8a08\u7b97\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5148\u307b\u3069\u8a08\u7b97\u3057\u305f\u300c\u8ab2\u300d\u300c\u5546\u54c1\u300d\u306e\u7d44\u307f\u5408\u308f\u305b\u306e\u8868\u3092\u6d3b\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4f8b\u3048\u3070\u3001\u300c\u55b6\u696d\u4e00\u8ab2\u300d\u3067\u300c\u5546\u54c1A\u300d\u3092\u6271\u3046\u9ad8\u6a4b\u3055\u3093\u306e\u30c7\u30fc\u30bf\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u3092\u60f3\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"551\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-31-1024x551.png\" alt=\"\" class=\"wp-image-2116\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-31-1024x551.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-31-300x162.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-31-768x414.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-31.png 1493w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u9ad8\u6a4b\u3055\u3093\u306e\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3059\u308b\u3068\u8a08\u7b97\u7528\u306e\u300c\u55b6\u696d\u4e00\u8ab2\u300d\u304b\u3064\u300c\u5546\u54c1A\u300d\u306e\u7d50\u679c\u304c\u5909\u308f\u308a\u307e\u3059\u3002\u3053\u3061\u3089\u306f\u9ad8\u6a4b\u3055\u3093\u3092\u9664\u5916\u3057\u305f\u5e73\u5747\u306e\u30c7\u30fc\u30bf\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"541\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-32-1024x541.png\" alt=\"\" class=\"wp-image-2117\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-32-1024x541.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-32-300x159.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-32-768x406.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-32.png 1496w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u306a\u306e\u3067\u3001\u7a7a\u767d\u3092\u9664\u5916\u3059\u308b\u305f\u3081\u7279\u5225\u306b\u4f55\u304b\u64cd\u4f5c\u3092\u3059\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<script data-jetpack-boost=\"ignore\" async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1873295597469931\"\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-1873295597469931\"\r\n     data-ad-slot=\"5031486087\"><\/ins>\r\n<script data-jetpack-boost=\"ignore\">\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n\n\n\n<h2 class=\"wp-block-heading\">0\u3092\u9664\u5916\u3057\u3066\u5e73\u5747\u3092\u51fa\u3059<\/h2>\n\n\n\n<p>\u6b21\u306b0\u3092\u9664\u5916\u3057\u3066\u5e73\u5747\u3092\u8a08\u7b97\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u7a7a\u767d\u3068\u306f\u9055\u3063\u3066\u3001\u6570\u5b57\u306e&#8221;0&#8243;\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001&#8221;0&#8243;\u3082\u542b\u3081\u3066\u8a08\u7b97\u3055\u308c\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u518d\u5ea6\u3001\u5148\u307b\u3069\u8a08\u7b97\u3057\u305f\u300c\u8ab2\u300d\u300c\u5546\u54c1\u300d\u306e\u7d44\u307f\u5408\u308f\u305b\u306e\u8868\u3092\u6d3b\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4f8b\u3048\u3070\u3001\u300c\u55b6\u696d\u4e00\u8ab2\u300d\u3067\u300c\u5546\u54c1A\u300d\u3092\u6271\u3046\u9ad8\u6a4b\u3055\u3093\u306e\u55b6\u696d\u6210\u7e3e\u304c0\u4ef6\u306e\u5834\u5408\u3092\u60f3\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"551\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-31-1024x551.png\" alt=\"\" class=\"wp-image-2116\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-31-1024x551.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-31-300x162.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-31-768x414.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-31.png 1493w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u9ad8\u6a4b\u3055\u3093\u306e\u30c7\u30fc\u30bf\u3092&#8221;0\u4ef6&#8221;\u306b\u3059\u308b\u3068\u8a08\u7b97\u7528\u306e\u300c\u55b6\u696d\u4e00\u8ab2\u300d\u304b\u3064\u300c\u5546\u54c1A\u300d\u306e\u7d50\u679c\u304c\u5909\u308f\u308a\u307e\u3059\u3002\u3053\u3061\u3089\u306f\u9ad8\u6a4b\u3055\u3093\u306e&#8221;0\u4ef6&#8221;\u3092\u542b\u3081\u305f\u5e73\u5747\u306e\u30c7\u30fc\u30bf\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"544\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-33-1024x544.png\" alt=\"\" class=\"wp-image-2118\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-33-1024x544.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-33-300x159.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-33-768x408.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-33.png 1495w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3053\u308c\u3067\u3082\u826f\u3044\u5834\u5408\u3082\u3042\u308b\u306e\u3067\u3059\u304c\u3001\u4f8b\u3048\u3070\u9ad8\u6a4b\u3055\u3093\u304c\u4f53\u8abf\u4e0d\u826f\u3067\u4f11\u6687\u3092\u53d6\u3063\u3066\u3044\u305f\u5834\u5408\u3001\u9069\u5207\u306a\u55b6\u696d\u6210\u7e3e\u306e\u5e73\u5747\u3092\u8868\u3057\u3066\u3044\u306a\u3044\u3068\u8003\u3048\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002\u306a\u306e\u3067\u3001&#8221;0&#8243;\u3092\u9664\u5916\u3057\u3066\u8a08\u7b97\u3059\u308b\u65b9\u6cd5\u3092\u8003\u3048\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u65b9\u6cd5\u306fAVERAGEIFS\u306e\u6761\u4ef6\u306b\u3001\u300c&#8221;0&#8243;\u3092\u9664\u5916\u3059\u308b\u300d\u3068\u3044\u3046\u6761\u4ef6\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u5177\u4f53\u7684\u306b\u306f\u3001\u30bb\u30ebI4\u306eAVERAGEIFS\u306e\u6570\u5f0f\u306b\u6761\u4ef63\u300c<span class=\"swl-inline-color has-swl-deep-01-color\">$E$4:$E$13,&#8221;&lt;&gt;0&#8243;<\/span>\u300d\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>=AVERAGEIFS($E$4:$E$13,$C$4:$C$13,G4,$D$4:$D$13,H4,<span class=\"swl-inline-color has-swl-deep-01-color\">$E$4:$E$13,&#8221;&lt;&gt;0&#8243;<\/span>)<\/p>\n<\/blockquote>\n\n\n\n<p><strong>\u6761\u4ef6\u7bc4\u56f23<\/strong>\u306b\u306f\u3001\u6761\u4ef6\u3092\u691c\u7d22\u3059\u308b\u305f\u3081\u306e\u300c\u55b6\u696d\u6210\u7e3e\u300d\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u30bb\u30ebE4~E13\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<span class=\"swl-marker mark_yellow\">\u3053\u3053\u3067\u306f\u3001\u4ed6\u306e\u7d44\u307f\u5408\u308f\u305b\u3082\u540c\u69d8\u306b\u5e73\u5747\u3092\u51fa\u3057\u305f\u3044\u306e\u3067\u7d76\u5bfe\u53c2\u7167\u3068\u3057\u307e\u3059\u3002<\/span>\u305d\u3057\u3066\u3001<strong>\u6761\u4ef63<\/strong>\u306b\u306f\u3001\u300c0\u4ee5\u5916\u300d\u3092\u8868\u3059\u300c&#8221;&lt;&gt;0&#8243;\u300d\u3092\u5165\u529b\u3057\u307e\u3059\u3002\uff08<span class=\"swl-marker mark_yellow\">\u4e0d\u7b49\u53f7\u3068\u6570\u5b57\u3092\u201d\u201d\u3067\u56f2\u3080<\/span>\uff09<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"345\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-34-1024x345.png\" alt=\"\" class=\"wp-image-2119\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-34-1024x345.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-34-300x101.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-34-768x258.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-34-1536x517.png 1536w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-34-2048x689.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>Enter\u30ad\u30fc\u3092\u62bc\u3059\u3068\u9ad8\u6a4b\u3055\u3093\u306e&#8221;0\u4ef6&#8221;\u3092\u9664\u5916\u3057\u305f\u5e73\u5747\u304c\u8a08\u7b97\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"543\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-35-1024x543.png\" alt=\"\" class=\"wp-image-2120\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-35-1024x543.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-35-300x159.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-35-768x408.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-35.png 1496w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3053\u306e\u6570\u5f0f\u3092\u30bb\u30ebI5~I9\u306b\u30b3\u30d4\u30da\u3059\u308b\u3068\u3001\u4ed6\u306e\u7d44\u307f\u5408\u308f\u305b\u3082\u540c\u69d8\u306b\u5e73\u5747\u304c\u8a08\u7b97\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" width=\"1024\" height=\"546\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-36-1024x546.png\" alt=\"\" class=\"wp-image-2121\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-36-1024x546.png 1024w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-36-300x160.png 300w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-36-768x409.png 768w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-36.png 1496w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-columns\">\n<div class=\"wp-block-column\">\n<figure class=\"wp-block-image size-large is-resized is-style-border\"><a href=\"https:\/\/www.amazon.co.jp\/dp\/B0F2LTMYGL\"><img decoding=\"async\" width=\"709\" height=\"1024\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u3010\u8868\u7d19\u3011\u30b3\u30f3\u30b5\u30eb\u6d41\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u30c6\u30af\u30cb\u30c3\u30af\u3000\uff5e\u3053\u308cExcel\u3067\u3069\u3046\u3084\u308b\u3093\u3060\u3063\u3051\uff1f\uff5e-709x1024.jpg\" alt=\"\" class=\"wp-image-6008\" style=\"width:200px\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u3010\u8868\u7d19\u3011\u30b3\u30f3\u30b5\u30eb\u6d41\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u30c6\u30af\u30cb\u30c3\u30af\u3000\uff5e\u3053\u308cExcel\u3067\u3069\u3046\u3084\u308b\u3093\u3060\u3063\u3051\uff1f\uff5e-709x1024.jpg 709w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u3010\u8868\u7d19\u3011\u30b3\u30f3\u30b5\u30eb\u6d41\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u30c6\u30af\u30cb\u30c3\u30af\u3000\uff5e\u3053\u308cExcel\u3067\u3069\u3046\u3084\u308b\u3093\u3060\u3063\u3051\uff1f\uff5e-208x300.jpg 208w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u3010\u8868\u7d19\u3011\u30b3\u30f3\u30b5\u30eb\u6d41\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u30c6\u30af\u30cb\u30c3\u30af\u3000\uff5e\u3053\u308cExcel\u3067\u3069\u3046\u3084\u308b\u3093\u3060\u3063\u3051\uff1f\uff5e.jpg 720w\" sizes=\"(max-width: 709px) 100vw, 709px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><a href=\"https:\/\/www.amazon.co.jp\/dp\/B0F2LTMYGL\"><strong>2025\u5e74\u7248\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u65b0\u6a5f\u80fd\u30fb\u65b0\u95a2\u6570<\/strong><\/a><\/p>\n\n\n\n<p>2021\u5e74\u4ee5\u964d\u3092\u4e2d\u5fc3\u306bExcel\u306b\u8ffd\u52a0\u3055\u308c\u305f\u6a5f\u80fd\u30fb\u95a2\u6570\u306e\u4e2d\u3067\u7279\u306b\u5b9f\u52d9\u306b\u5f79\u7acb\u3064\u3082\u306e\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3084\u4ed6\u306e\u6a5f\u80fd\u30fb\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u305f\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af\u3082\u7d39\u4ecb\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column\">\n<figure class=\"wp-block-image size-large is-resized is-style-border\"><a href=\"https:\/\/www.amazon.co.jp\/dp\/B0DPG4GYWC\"><img decoding=\"async\" width=\"709\" height=\"1024\" src=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u8868\u7d19-709x1024.jpg\" alt=\"\" class=\"wp-image-6009\" style=\"width:200px\" srcset=\"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u8868\u7d19-709x1024.jpg 709w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u8868\u7d19-208x300.jpg 208w, https:\/\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/\u8868\u7d19.jpg 720w\" sizes=\"(max-width: 709px) 100vw, 709px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><strong><a href=\"https:\/\/www.amazon.co.jp\/dp\/B0DPG4GYWC\">\u30b3\u30f3\u30b5\u30eb\u6d41\u5b9f\u52d9\u3067\u5f79\u7acb\u3064Excel\u30c6\u30af\u30cb\u30c3\u30af<\/a><\/strong><\/p>\n\n\n\n<p>\u30b3\u30f3\u30b5\u30eb\u30bf\u30f3\u30c8\u3068\u3057\u3066\u69d8\u3005\u306a\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u5f93\u4e8b\u3057\u3066\u304d\u305f\u8457\u8005\u304c\u3001\u5b9f\u52d9\u306b\u304a\u3044\u3066\u5b9f\u969b\u306b\u6d3b\u7528\u3057\u305fExcel\u306e\u30c6\u30af\u30cb\u30c3\u30af\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u8457\u8005\u81ea\u8eab\u304c\u300c\u3042\u308c\uff1f\u3069\u3046\u3059\u308c\u3070\u3044\u3044\u3093\u3060\u308d\u3046\u300d\u3068\u60a9\u3093\u3060\u90e8\u5206\u3092\u4e2d\u5fc3\u306b\u30d4\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-swl-main-color has-alpha-channel-opacity has-swl-main-background-color has-background is-style-wide\"\/>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u3067\u6761\u4ef6\u306b\u5408\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u306e\u5e73\u5747\u3092\u51fa\u3057\u305f\u3044\u5834\u5408\u3001AVERAGEIF\/AVERAGEIFS\u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u3067\u306f\u30014\u30d1\u30bf\u30fc\u30f3\u306eAVERAGEIF\/AVERAGEIFS\u3092\u6d3b\u7528\u3057\u305f\u5e73\u5747\u306e\u7b97\u51fa\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 1\u3064\u306e [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2123,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"swell_btn_cv_data":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[38],"tags":[444,445,37,8],"class_list":["post-2097","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-averageif","tag-averageifs","tag-excel","tag-8"],"acf":[],"jetpack_featured_media_url":"https:\/\/amadoc-insight.com\/wp-content\/uploads\/2024\/01\/image-37.png","jetpack-related-posts":[{"id":5623,"url":"https:\/\/amadoc-insight.com\/?p=5623","url_meta":{"origin":2097,"position":0},"title":"\u3010Excel\u3011COUNTIF\u95a2\u6570\u3001SUMIF\u95a2\u6570\u3001AVERAGEIF\u95a2\u6570\u306a\u3069\u3067\u6761\u4ef6\u306b\u300c\uff5e\u4ee5\u4e0a\u300d\u300c\uff5e\u4ee5\u4e0b\u300d\u3092\u6307\u5b9a\u3059\u308b\u65b9\u6cd5","author":"Junya","date":"2025\u5e743\u67089\u65e5","format":false,"excerpt":"COUNTIF\u95a2\u6570\u3001SUMIF\u95a2\u6570\u3001AVERAGEIF\u95a2\u6570\u306a\u3069\u3067\u306f\u3001\u6761\u4ef6\u306b\u300c\uff5e\u4ee5\u4e0a\u300d\u300c\uff5e\u4ee5\u4e0b\u300d\u3068\u3044\u3063\u2026","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/amadoc-insight.com\/?cat=38"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-443.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-443.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-443.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-443.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-443.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-443.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":5991,"url":"https:\/\/amadoc-insight.com\/?p=5991","url_meta":{"origin":2097,"position":1},"title":"\u3010Excel\u3011\u30ab\u30c6\u30b4\u30ea\u5225\u95a2\u6570\u4e00\u89a7","author":"Junya","date":"2025\u5e743\u670819\u65e5","format":false,"excerpt":"Excel\u306e\u95a2\u6570\u3092\u30ab\u30c6\u30b4\u30ea\u5225\u306b\u6574\u7406\u3057\u3066\u3044\u307e\u3059\u3002\u3054\u5229\u7528\u3055\u308c\u3066\u3044\u308bExcel\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u3088\u3063\u3066\u306f\u4f7f\u7528\u3067\u2026","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/amadoc-insight.com\/?cat=38"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-738.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-738.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-738.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-738.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-738.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-738.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":4860,"url":"https:\/\/amadoc-insight.com\/?p=4860","url_meta":{"origin":2097,"position":2},"title":"\u3010Excel\u3011\u69d8\u3005\u306a\u6761\u4ef6\u3067\u6570\u3092\u6570\u3048\u308b\u65b9\u6cd5\uff08COUNTA\u95a2\u6570\u3001COUNT\u95a2\u6570\u3001COUNTIF\u95a2\u6570\u3001COUNTIFS\u95a2\u6570\uff09","author":"Junya","date":"2025\u5e742\u670827\u65e5","format":false,"excerpt":"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u69d8\u3005\u306a\u6761\u4ef6\u3067\u6570\u3092\u6570\u3048\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u96c6\u8a08\u306e\u57fa\u672c\u306f\u6570\u3092\u6570\u3048\u308b\u3053\u3068\u3067\u3059\u304c\u3001Excel\u306b\u2026","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/amadoc-insight.com\/?cat=38"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-967.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-967.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-967.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-967.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-967.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-967.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":3858,"url":"https:\/\/amadoc-insight.com\/?p=3858","url_meta":{"origin":2097,"position":3},"title":"\u3010Excel\u3011TEXTSPLIT\u95a2\u6570\u3092\u4f7f\u3063\u3066\u8a18\u53f7\u306a\u3069\u3067\u533a\u5207\u3089\u308c\u305f\u6587\u5b57\u5217\u3092\u52b9\u7387\u7684\u306b\u5206\u5272\u3059\u308b\u65b9\u6cd5","author":"Junya","date":"2025\u5e742\u670817\u65e5","format":false,"excerpt":"TEXTSPLIT\u95a2\u6570\u3092\u4f7f\u3048\u3070\u3001\u8a18\u53f7\u306a\u3069\u3067\u533a\u5207\u3089\u308c\u305f\u6587\u5b57\u5217\u3092\u52b9\u7387\u7684\u306b\u5206\u5272\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 =TE\u2026","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/amadoc-insight.com\/?cat=38"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-102.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-102.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-102.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-102.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-102.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/02\/image-102.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":6788,"url":"https:\/\/amadoc-insight.com\/?p=6788","url_meta":{"origin":2097,"position":4},"title":"\u3010Excel\u3011\u7d71\u5408\u6a5f\u80fd\u3092\u4f7f\u3063\u3066\u8907\u6570\u30b7\u30fc\u30c8\u306e\u96c6\u8a08\u3092\u884c\u3046","author":"Junya","date":"2025\u5e746\u67086\u65e5","format":false,"excerpt":"Excel\u3067\u306f\u3001\u8907\u6570\u306e\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u4e00\u3064\u306b\u96c6\u8a08\u3057\u305f\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u3001\u5404\u62c5\u5f53\u8005\u306e\u55b6\u696d\u6210\u7e3e\u8868\u2026","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/amadoc-insight.com\/?cat=38"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/06\/image-211.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/06\/image-211.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/06\/image-211.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/06\/image-211.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/06\/image-211.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/06\/image-211.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":5240,"url":"https:\/\/amadoc-insight.com\/?p=5240","url_meta":{"origin":2097,"position":5},"title":"\u3010Excel\u3011\u6587\u5b57\u5217\u3092\u6570\u5024\u30c7\u30fc\u30bf\u306b\u5909\u63db\u3059\u308b2\u3064\u306e\u65b9\u6cd5","author":"Junya","date":"2025\u5e743\u67084\u65e5","format":false,"excerpt":"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u6587\u5b57\u5217\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u3066\u3044\u308b\u6570\u5b57\u3092\u6570\u5024\u30c7\u30fc\u30bf\u306b\u5909\u63db\u3059\u308b2\u3064\u306e\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u95a2\u9023\u8a18\u4e8b\u2026","rel":"","context":"Excel","block_context":{"text":"Excel","link":"https:\/\/amadoc-insight.com\/?cat=38"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-201.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-201.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-201.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-201.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-201.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/amadoc-insight.com\/wp-content\/uploads\/2025\/03\/image-201.png?resize=1400%2C800&ssl=1 4x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/amadoc-insight.com\/index.php?rest_route=\/wp\/v2\/posts\/2097","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/amadoc-insight.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/amadoc-insight.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/amadoc-insight.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/amadoc-insight.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2097"}],"version-history":[{"count":9,"href":"https:\/\/amadoc-insight.com\/index.php?rest_route=\/wp\/v2\/posts\/2097\/revisions"}],"predecessor-version":[{"id":6210,"href":"https:\/\/amadoc-insight.com\/index.php?rest_route=\/wp\/v2\/posts\/2097\/revisions\/6210"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/amadoc-insight.com\/index.php?rest_route=\/wp\/v2\/media\/2123"}],"wp:attachment":[{"href":"https:\/\/amadoc-insight.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/amadoc-insight.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2097"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/amadoc-insight.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}