CINXE.COM

<!DOCTYPE html> <html lang="ja" dir="ltr"> <head> <meta charset="utf-8" /> <title>Excel関数使い方解説一覧 | できるネット</title> <link rel="canonical" href="https://dekiru.net/category/windows-office/excel-kansu/" /> <script> var dataLayer = dataLayer || []; dataLayer.push({ 'category': 'windows-office-excel-kansu' }); </script> <link rel="preconnect" href="https://fonts.googleapis.com" /> <link rel="preconnect" href="https://fonts.gstatic.com" /> <link rel="preconnect" href="https://www.googletagmanager.com" /> <link rel="preconnect" href="https://platform.twitter.com" /> <link rel="preconnect" href="https://connect.facebook.net" /> <link rel="preconnect" href="https://www.facebook.com" /> <link rel="preconnect" href="https://pagead2.googlesyndication.com" /> <link rel="preconnect" href="https://adservice.google.co.jp" /> <link rel="preload" as="style" href="/static/v2018/css/s.min.css" /> <link rel="preload" as="style" href="/static/v2018/fontawesome/css/all.min.css" /> <link rel="preload" as="font" type="font/woff2" href="/static/v2018/fontawesome/webfonts/fa-brands-400.woff2" crossorigin /> <link rel="preload" as="font" type="font/woff2" href="/static/v2018/fontawesome/webfonts/fa-solid-900.woff2" crossorigin /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <link rel="stylesheet" href="/static/v2018/css/s.min.css?202402202116" /> <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons&display=swap" media="print" onload="this.media='all';this.onload=null;" /> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro&display=swap" media="print" onload="this.media='all';this.onload=null;" /> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Code+Pro&display=swap" media="print" onload="this.media='all';this.onload=null;" /> <link rel="stylesheet" href="/static/v2018/fontawesome/css/all.min.css" media="print" onload="this.media='all';this.onload=null;" /> <link href="/feed/" rel="alternate" type="application/rss+xml" title="最新記事のRSSフィード" /> <link href="/static/img/apple-touch-icon.png" rel="apple-touch-icon" /> <link href="/static/img/favicon.png" type="image/png" rel="icon" /> <link href="/static/img/favicon.ico" type="image/x-icon" rel="shortcut icon" /> <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-M6PFDT');</script> <script async="async" src="https://www.googletagservices.com/tag/js/gpt.js"></script> <script> !function(a9,a,p,s,t,A,g){if(a[a9])return;function q(c,r){a[a9]._Q.push([c,r])}a[a9]={init:function(){q("i",arguments)},fetchBids:function(){q("f",arguments)},setDisplayBids:function(){},_Q:[]};A=p.createElement(s);A.async=!0;A.src=t;g=p.getElementsByTagName(s)[0];g.parentNode.insertBefore(A,g)}("apstag",window,document,"script","//c.amazon-adsystem.com/aax2/apstag.js"); apstag.init({ pubID: '3583', adServer: 'googletag', simplerGPT: true }); </script> <script> var googletag = googletag || {}; googletag.cmd = googletag.cmd || []; </script> <script> var gptAdSlots = []; googletag.cmd.push(function() { var mapping01 = googletag.sizeMapping().addSize([835, 0], [[300, 250], [300, 300]]).addSize([335, 0], ['fluid', [300, 250], [300, 300], [320, 50], [320, 100], [336, 280]]).addSize([0, 0], ['fluid', [300, 250], [300, 300]]).build(); var mapping02 = googletag.sizeMapping().addSize([835, 0], [[728, 90], [970, 90], [970, 250]]).addSize([335, 0], ['fluid', [300, 250], [320, 50], [320, 100], [336, 280]]).addSize([0, 0], ['fluid', [300, 250]]).build(); var mapping03 = googletag.sizeMapping().addSize([835, 0], [[728, 90], [970, 90], [970, 250]]).addSize([335, 0], ['fluid', [300, 250], [320, 50], [320, 100], [336, 280]]).addSize([0, 0], ['fluid', [300, 250]]).build(); var mapping04 = googletag.sizeMapping().addSize([835, 0], [[728, 90], [970, 90], [970, 250]]).addSize([335, 0], ['fluid', [300, 250], [320, 50], [320, 100], [336, 280]]).addSize([0, 0], ['fluid', [300, 250]]).build(); gptAdSlots[0] = googletag.defineSlot('/49282802/ipc-dekirunet/all-list/categridrect01', ['fluid', [300, 300], [300, 250]], 'div-gpt-ad-all-list_categridrect01').defineSizeMapping(mapping01).setTargeting('i202cat_s', ['excel-kansu']).addService(googletag.pubads()); gptAdSlots[1] = googletag.defineSlot('/49282802/ipc-dekirunet/all-list/catebanner01', ['fluid', [300, 250]], 'div-gpt-ad-all-list_catebanner01').defineSizeMapping(mapping02).setTargeting('i202cat_s', ['excel-kansu']).addService(googletag.pubads()); gptAdSlots[2] = googletag.defineSlot('/49282802/ipc-dekirunet/all-list/catebanner02', ['fluid', [300, 250]], 'div-gpt-ad-all-list_catebanner02').defineSizeMapping(mapping03).setTargeting('i202cat_s', ['excel-kansu']).addService(googletag.pubads()); gptAdSlots[3] = googletag.defineSlot('/49282802/ipc-dekirunet/all-list/catefoot01', ['fluid', [300, 250]], 'div-gpt-ad-all-list_catefoot01').defineSizeMapping(mapping04).setTargeting('i202cat_s', ['excel-kansu']).addService(googletag.pubads()); googletag.pubads().disableInitialLoad(); googletag.enableServices(); }); </script> <script> googletag.cmd.push(function(){ apstag.fetchBids({ slots: [gptAdSlots[0], gptAdSlots[1]], timeout: 2000 }, function(bids) { apstag.setDisplayBids(); googletag.pubads().refresh([gptAdSlots[0], gptAdSlots[1]]); }); }); </script> <meta name="keywords" content="エクセル関数,使い方,引数" /> <meta name="description" content="Excel（エクセル）で使える480種類以上の関数の使い方を解説。関数の機能や入力方法、引数がわかるのはもちろん、使用頻度が高い関数は画面付きの使用例で具体的な活用シーンを紹介しています。" /> <meta property="og:title" content="Excel関数使い方解説一覧（1 / 25 ページ）" /> <meta property="og:url" content="https://dekiru.net/category/windows-office/excel-kansu/" /> <meta property="og:site_name" content="できるネット" /> <meta property="og:description" content="Excel（エクセル）で使える480種類以上の関数の使い方を解説。関数の機能や入力方法、引数がわかるのはもちろん、使用頻度が高い関数は画面付きの使用例で具体的な活用シーンを紹介しています。" /> <meta property="og:image" content="https://dekiru.net/upload_docs/img/ogp_excel_kansu2.png" /> <meta property="og:image:secure_url" content="https://dekiru.net/upload_docs/img/ogp_excel_kansu2.png" /> <meta property="og:type" content="website" /> <meta name="twitter:card" content="summary" /> <meta name="twitter:site" content="@dekirunet" /> <meta name="twitter:creator" content="@dekirunet" /> <script type="application/ld+json"> { "@context": "http://schema.org", "@type": "WebPage", "name": "Excel関数使い方解説一覧", "description": "Excel（エクセル）で使える480種類以上の関数の使い方を解説。関数の機能や入力方法、引数がわかるのはもちろん、使用頻度が高い関数は画面付きの使用例で具体的な活用シーンを紹介しています。", "headline": "Excel関数使い方解説一覧", "datePublished": "2014-04-30T12:00:06+09:00", "dateModified": "2025-01-07T11:13:21+09:00", "image": { "@type": "ImageObject", "url": "https://dekiru.net/upload_docs/img/ogp_excel_kansu2.png", "width": 640, "height": 300 }, "author": { "@type": "Organization", "name": "できるネット編集部" }, "publisher": { "@type": "Organization", "name": "できるネット編集部", "logo": { "@type": "ImageObject", "url": "https://qa.dekiru.net/static/v2018/img/dekiru-logo.png", "width": 484, "height": 101 } } } </script> <script type="application/ld+json"> { "@context": "https://schema.org", "@type": "BreadcrumbList", "itemListElement": [ { "@type": "ListItem", "position": 1, "item": "https://dekiru.net/", "name": "トップページ" }, { "@type": "ListItem", "position": 2, "item": "https://dekiru.net/category/windows-office/", "name": "Windows/Office" }, { "@type": "ListItem", "position": 3, "item": "https://dekiru.net/category/windows-office/excel-kansu/", "name": "Excel関数" } ] } </script> </head> <body id="top" class="page-archives"> <div class="block-site-header"> <header> <div class="module-site-header-inner"> <div class="block-site-banner-area"> <h1 class="module-site-banner"> <a href="/"> <span class="module-site-banner-logo"><img src="/static/v2018/img/dekiru-logo.svg" alt="できるネット" /></span> <span class="module-site-banner-tagline">新たな一歩を応援するメディア</span> </a> </h1> </div> <div class="block-header-menu-area"> <div class="module-header-sub-menu"> <ul> <li><a href="https://twitter.com/dekirunet/" target="_blank"> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 1200 1227" fill="none" height="14" aria-hidden="true"> <path d="M714.163 519.284L1160.89 0H1055.03L667.137 450.887L357.328 0H0L468.492 681.821L0 1226.37H105.866L515.491 750.218L842.672 1226.37H1200L714.137 519.284H714.163ZM569.165 687.828L521.697 619.934L144.011 79.6944H306.615L611.412 515.685L658.88 583.579L1055.08 1150.3H892.476L569.165 687.854V687.828Z" fill="#000000" /> </svg> <span class="module-hidden">X（旧 Twitter）</span></a></li> <li><a href="https://www.facebook.com/dekirunet" target="_blank"><i class="fab fa-facebook fa-lg" aria-hidden="true"></i><span class="module-hidden">Facebook</span></a></li> <li><a href="https://www.youtube.com/user/dekirunet" target="_blank"><i class="fab fa-youtube fa-lg" aria-hidden="true"></i><span class="module-hidden">YouTube</span></a></li> <li><a href="/about/"><i class="fas fa-angle-right fa-lg" aria-hidden="true"></i>できるネットについて</a></li> </ul> </div> <div class="module-header-menu-btn"> <button class="module-header-menu-btn-search" id="role-header-menu-btn-search"> <i class="module-svg-icon" aria-hidden="true"> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24" width="24px" height="24px" fill="currentColor"> <path d="M0 0h24v24H0z" fill="none"/><path d="M15.5 14h-.79l-.28-.27C15.41 12.59 16 11.11 16 9.5 16 5.91 13.09 3 9.5 3S3 5.91 3 9.5 5.91 16 9.5 16c1.61 0 3.09-.59 4.23-1.57l.27.28v.79l5 4.99L20.49 19l-4.99-5zm-6 0C7.01 14 5 11.99 5 9.5S7.01 5 9.5 5 14 7.01 14 9.5 11.99 14 9.5 14z" /> </svg> </i><span>キーワードで検索</span> </button><button class="module-header-menu-btn-category" id="role-header-menu-btn-category"> <i class="module-svg-icon" aria-hidden="true"> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24" width="24px" height="24px" fill="currentColor"> <path d="M0 0h24v24H0z" fill="none"/><path d="M3 13h2v-2H3v2zm0 4h2v-2H3v2zm0-8h2V7H3v2zm4 4h14v-2H7v2zm0 4h14v-2H7v2zM7 7v2h14V7H7z" /> </svg> </i><span>カテゴリーから探す</span> </button> </div> </div> </div> </header> </div> <div class="block-main-area"> <main> <div class="block-archive"> <div class="module-topick-path"> <div class="module-topick-path-inner"> <ul><li><a href="/"><i class="module-topick-path-home" aria-hidden="true"></i><span class="module-hidden">できるネット</span></a></li><li><a href="/category/windows-office/"><i class="fas fa-angle-right fa-lg" aria-hidden="true"></i>Windows/Office</a></li><li><i class="fas fa-angle-right fa-lg" aria-hidden="true"></i>Excel関数</li> </ul> </div> </div> <div class="block-top-main-head-area"> <div class="block-archives-head"> <div class="module-archives-head-inner"> <div class="module-archives-head-header"> <h2 class="module-archives-head-title">Excel関数</h2> </div> <div class="module-archives-head-summary"> <p>Excel（エクセル）で使える480種類以上の関数の使い方を解説。関数の機能や入力方法、引数がわかるのはもちろん、使用頻度が高い関数は画面付きの使用例で具体的な活用シーンを紹介しています。</p> </div> </div> </div> </div> <div class="block-hot-article-item-area"> <div class="module-hot-article-item-area-header"> <div class="module-hot-article-item-area-header-inner"> <h2 class="module-hot-article-item-area-title">Excel関数の注目記事</h2> </div> </div> <div class="module-hot-article-item-area-wrap-inner"> <div class="module-article-list-ad"> <div class="module-article-list-ad-inner"> <aside>  <div id="div-gpt-ad-all-list_categridrect01"> <script> googletag.cmd.push(function() { googletag.display('div-gpt-ad-all-list_categridrect01'); }); </script> </div> </aside> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/4429/" rel="bookmark"> <h3 class="module-article-item-title"> Excel関数機能別一覧（全510関数） </h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2018/10/ogp_exkansu-thumb-600xauto-47142.jpg" width="600" height="315" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2024-03-21T21:00:00+09:00">21:00 2024.03.21</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=Excel%E9%96%A2%E6%95%B0%20%E6%A9%9F%E8%83%BD%E5%88%A5%E4%B8%80%E8%A6%A7%EF%BC%88%E5%85%A8510%E9%96%A2%E6%95%B0%EF%BC%89%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F4429%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F4429%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/4429/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/4429/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F4429%2F&title=Excel%E9%96%A2%E6%95%B0%20%E6%A9%9F%E8%83%BD%E5%88%A5%E4%B8%80%E8%A6%A7%EF%BC%88%E5%85%A8510%E9%96%A2%E6%95%B0%EF%BC%89%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/21009/" rel="bookmark"> <h3 class="module-article-item-title"> ExcelのVLOOKUP関数の使い方【エクセル時短】 </h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2021/12/ex-jitan144-00-1-thumb-600xauto-66930.png" width="600" height="315" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2024-10-11T15:00:00+09:00">15:00 2024.10.11</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=Excel%E3%81%AEVLOOKUP%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%E3%80%90%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E6%99%82%E7%9F%AD%E3%80%91%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F21009%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F21009%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/21009/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/21009/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F21009%2F&title=Excel%E3%81%AEVLOOKUP%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%E3%80%90%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E6%99%82%E7%9F%AD%E3%80%91%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/19911/" rel="bookmark"> <h3 class="module-article-item-title"> SUMIF関数の使い方 </h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2020/04/ex-jitan139-00-thumb-600xauto-57870.png" width="600" height="315" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2020-04-28T20:30:05+09:00">20:30 2020.04.28</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=SUMIF%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F19911%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F19911%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/19911/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/19911/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F19911%2F&title=SUMIF%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/19927/" rel="bookmark"> <h3 class="module-article-item-title"> SUMIFS関数の使い方 </h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2020/04/ex-jitan140-00-thumb-600xauto-58329.png" width="600" height="315" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2020-05-01T17:30:01+09:00">17:30 2020.05.01</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=SUMIFS%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F19927%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F19927%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/19927/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/19927/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F19927%2F&title=SUMIFS%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/19807/" rel="bookmark"> <h3 class="module-article-item-title"> COUNTIF関数の使い方 </h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/10/20231012_o0100-thumb-600xauto-72222.png" width="600" height="315" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-10-12T15:00:00+09:00">15:00 2023.10.12</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=COUNTIF%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F19807%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F19807%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/19807/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/19807/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F19807%2F&title=COUNTIF%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/19816/" rel="bookmark"> <h3 class="module-article-item-title"> COUNTIFS関数の使い方 </h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/10/20231012_o0200-thumb-600xauto-72223.png" width="600" height="315" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-10-12T15:30:00+09:00">15:30 2023.10.12</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=COUNTIFS%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F19816%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F19816%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/19816/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/19816/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F19816%2F&title=COUNTIFS%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> </div> </div> </div> <div class="block-ads"> <aside>  <div id="div-gpt-ad-all-list_catebanner01"> <script> googletag.cmd.push(function() { googletag.display('div-gpt-ad-all-list_catebanner01'); }); </script> </div> </aside> </div> <div class="block-article-item-area module-sub-article-area"> <div class="module-article-item-area-inner"> <div class="module-article-item-list"> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/26073/" rel="bookmark"> <h3 class="module-article-item-title">仕事が雑な人と思われないために！ Excelで知っておきたい5つの「常識ルール」</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2024/12/20241220_ta0100-thumb-180xauto-75913.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2025-01-07T06:00:00+09:00">06:00 2025.01.07</time></p> <p><a href="/category/windows-office/excel/">Excel</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=%E4%BB%95%E4%BA%8B%E3%81%8C%E9%9B%91%E3%81%AA%E4%BA%BA%E3%81%A8%E6%80%9D%E3%82%8F%E3%82%8C%E3%81%AA%E3%81%84%E3%81%9F%E3%82%81%E3%81%AB%EF%BC%81%20Excel%E3%81%A7%E7%9F%A5%E3%81%A3%E3%81%A6%E3%81%8A%E3%81%8D%E3%81%9F%E3%81%845%E3%81%A4%E3%81%AE%E3%80%8C%E5%B8%B8%E8%AD%98%E3%83%AB%E3%83%BC%E3%83%AB%E3%80%8D%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F26073%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F26073%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/26073/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/26073/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F26073%2F&title=%E4%BB%95%E4%BA%8B%E3%81%8C%E9%9B%91%E3%81%AA%E4%BA%BA%E3%81%A8%E6%80%9D%E3%82%8F%E3%82%8C%E3%81%AA%E3%81%84%E3%81%9F%E3%82%81%E3%81%AB%EF%BC%81%20Excel%E3%81%A7%E7%9F%A5%E3%81%A3%E3%81%A6%E3%81%8A%E3%81%8D%E3%81%9F%E3%81%845%E3%81%A4%E3%81%AE%E3%80%8C%E5%B8%B8%E8%AD%98%E3%83%AB%E3%83%BC%E3%83%AB%E3%80%8D%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/25674/" rel="bookmark"> <h3 class="module-article-item-title">Excel関数とは？よく使う基本の関数と主なエラー値を初心者向けに解説【エクセル時短】</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2024/11/ex-jitan234-00-1-thumb-180xauto-75447.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2024-11-18T06:00:00+09:00">06:00 2024.11.18</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=Excel%E9%96%A2%E6%95%B0%E3%81%A8%E3%81%AF%EF%BC%9F%20%E3%82%88%E3%81%8F%E4%BD%BF%E3%81%86%E5%9F%BA%E6%9C%AC%E3%81%AE%E9%96%A2%E6%95%B0%E3%81%A8%E4%B8%BB%E3%81%AA%E3%82%A8%E3%83%A9%E3%83%BC%E5%80%A4%E3%82%92%E5%88%9D%E5%BF%83%E8%80%85%E5%90%91%E3%81%91%E3%81%AB%E8%A7%A3%E8%AA%AC%E3%80%90%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E6%99%82%E7%9F%AD%E3%80%91%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F25674%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F25674%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/25674/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/25674/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F25674%2F&title=Excel%E9%96%A2%E6%95%B0%E3%81%A8%E3%81%AF%EF%BC%9F%20%E3%82%88%E3%81%8F%E4%BD%BF%E3%81%86%E5%9F%BA%E6%9C%AC%E3%81%AE%E9%96%A2%E6%95%B0%E3%81%A8%E4%B8%BB%E3%81%AA%E3%82%A8%E3%83%A9%E3%83%BC%E5%80%A4%E3%82%92%E5%88%9D%E5%BF%83%E8%80%85%E5%90%91%E3%81%91%E3%81%AB%E8%A7%A3%E8%AA%AC%E3%80%90%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E6%99%82%E7%9F%AD%E3%80%91%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/24520/" rel="bookmark"> <h3 class="module-article-item-title">Excelで文字列に含まれる空白（スペース）を一括削除。置換機能とSUBSTITUTE関数を使い分ける</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/09/ex-jitan218-00-thumb-180xauto-72027.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2024-10-11T21:30:00+09:00">21:30 2024.10.11</time></p> <p><a href="/category/windows-office/excel/">Excel</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=Excel%E3%81%A7%E6%96%87%E5%AD%97%E5%88%97%E3%81%AB%E5%90%AB%E3%81%BE%E3%82%8C%E3%82%8B%E7%A9%BA%E7%99%BD%EF%BC%88%E3%82%B9%E3%83%9A%E3%83%BC%E3%82%B9%EF%BC%89%E3%82%92%E4%B8%80%E6%8B%AC%E5%89%8A%E9%99%A4%E3%80%82%E7%BD%AE%E6%8F%9B%E6%A9%9F%E8%83%BD%E3%81%A8SUBSTITUTE%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E3%81%84%E5%88%86%E3%81%91%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F24520%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F24520%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/24520/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/24520/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F24520%2F&title=Excel%E3%81%A7%E6%96%87%E5%AD%97%E5%88%97%E3%81%AB%E5%90%AB%E3%81%BE%E3%82%8C%E3%82%8B%E7%A9%BA%E7%99%BD%EF%BC%88%E3%82%B9%E3%83%9A%E3%83%BC%E3%82%B9%EF%BC%89%E3%82%92%E4%B8%80%E6%8B%AC%E5%89%8A%E9%99%A4%E3%80%82%E7%BD%AE%E6%8F%9B%E6%A9%9F%E8%83%BD%E3%81%A8SUBSTITUTE%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E3%81%84%E5%88%86%E3%81%91%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/24420/" rel="bookmark"> <h3 class="module-article-item-title">Excel で「1」「2」「3」のような連続した数字を入力するには？今さら聞けないオートフィルの基本</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/09/20230913_o0101-thumb-180xauto-71974.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2024-10-11T21:15:00+09:00">21:15 2024.10.11</time></p> <p><a href="/category/windows-office/excel/">Excel</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=Excel%20%E3%81%A7%E3%80%8C1%E3%80%8D%E3%80%8C2%E3%80%8D%E3%80%8C3%E3%80%8D%E3%81%AE%E3%82%88%E3%81%86%E3%81%AA%E9%80%A3%E7%B6%9A%E3%81%97%E3%81%9F%E6%95%B0%E5%AD%97%E3%82%92%E5%85%A5%E5%8A%9B%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%EF%BC%9F%20%E4%BB%8A%E3%81%95%E3%82%89%E8%81%9E%E3%81%91%E3%81%AA%E3%81%84%E3%82%AA%E3%83%BC%E3%83%88%E3%83%95%E3%82%A3%E3%83%AB%E3%81%AE%E5%9F%BA%E6%9C%AC%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F24420%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F24420%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/24420/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/24420/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F24420%2F&title=Excel%20%E3%81%A7%E3%80%8C1%E3%80%8D%E3%80%8C2%E3%80%8D%E3%80%8C3%E3%80%8D%E3%81%AE%E3%82%88%E3%81%86%E3%81%AA%E9%80%A3%E7%B6%9A%E3%81%97%E3%81%9F%E6%95%B0%E5%AD%97%E3%82%92%E5%85%A5%E5%8A%9B%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%EF%BC%9F%20%E4%BB%8A%E3%81%95%E3%82%89%E8%81%9E%E3%81%91%E3%81%AA%E3%81%84%E3%82%AA%E3%83%BC%E3%83%88%E3%83%95%E3%82%A3%E3%83%AB%E3%81%AE%E5%9F%BA%E6%9C%AC%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/18663/" rel="bookmark"> <h3 class="module-article-item-title">Excelの四捨五入・切り捨て・切り上げを総まとめ。ROUND関数を使いこなそう【エクセル時短】</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2022/01/20210111_o01-thumb-180xauto-67050.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2024-10-11T15:50:00+09:00">15:50 2024.10.11</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=Excel%E3%81%AE%E5%9B%9B%E6%8D%A8%E4%BA%94%E5%85%A5%E3%83%BB%E5%88%87%E3%82%8A%E6%8D%A8%E3%81%A6%E3%83%BB%E5%88%87%E3%82%8A%E4%B8%8A%E3%81%92%E3%82%92%E7%B7%8F%E3%81%BE%E3%81%A8%E3%82%81%E3%80%82ROUND%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E3%81%84%E3%81%93%E3%81%AA%E3%81%9D%E3%81%86%E3%80%90%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E6%99%82%E7%9F%AD%E3%80%91%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F18663%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F18663%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/18663/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/18663/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F18663%2F&title=Excel%E3%81%AE%E5%9B%9B%E6%8D%A8%E4%BA%94%E5%85%A5%E3%83%BB%E5%88%87%E3%82%8A%E6%8D%A8%E3%81%A6%E3%83%BB%E5%88%87%E3%82%8A%E4%B8%8A%E3%81%92%E3%82%92%E7%B7%8F%E3%81%BE%E3%81%A8%E3%82%81%E3%80%82ROUND%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E3%81%84%E3%81%93%E3%81%AA%E3%81%9D%E3%81%86%E3%80%90%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E6%99%82%E7%9F%AD%E3%80%91%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/21009/" rel="bookmark"> <h3 class="module-article-item-title">ExcelのVLOOKUP関数の使い方【エクセル時短】</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2021/12/ex-jitan144-00-1-thumb-180xauto-66930.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2024-10-11T15:00:00+09:00">15:00 2024.10.11</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=Excel%E3%81%AEVLOOKUP%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%E3%80%90%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E6%99%82%E7%9F%AD%E3%80%91%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F21009%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F21009%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/21009/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/21009/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F21009%2F&title=Excel%E3%81%AEVLOOKUP%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%E3%80%90%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E6%99%82%E7%9F%AD%E3%80%91%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/24730/" rel="bookmark"> <h3 class="module-article-item-title">Excelで2024年のカレンダーを作る3つの方法。テンプレート2種と数式での自作を使い分ける！</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/11/ex-jitan221-00-thumb-180xauto-72585.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2024-05-28T13:00:00+09:00">13:00 2024.05.28</time></p> <p><a href="/category/windows-office/excel/">Excel</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=Excel%E3%81%A72024%E5%B9%B4%E3%81%AE%E3%82%AB%E3%83%AC%E3%83%B3%E3%83%80%E3%83%BC%E3%82%92%E4%BD%9C%E3%82%8B3%E3%81%A4%E3%81%AE%E6%96%B9%E6%B3%95%E3%80%82%E3%83%86%E3%83%B3%E3%83%97%E3%83%AC%E3%83%BC%E3%83%882%E7%A8%AE%E3%81%A8%E6%95%B0%E5%BC%8F%E3%81%A7%E3%81%AE%E8%87%AA%E4%BD%9C%E3%82%92%E4%BD%BF%E3%81%84%E5%88%86%E3%81%91%E3%82%8B%EF%BC%81%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F24730%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F24730%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/24730/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/24730/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F24730%2F&title=Excel%E3%81%A72024%E5%B9%B4%E3%81%AE%E3%82%AB%E3%83%AC%E3%83%B3%E3%83%80%E3%83%BC%E3%82%92%E4%BD%9C%E3%82%8B3%E3%81%A4%E3%81%AE%E6%96%B9%E6%B3%95%E3%80%82%E3%83%86%E3%83%B3%E3%83%97%E3%83%AC%E3%83%BC%E3%83%882%E7%A8%AE%E3%81%A8%E6%95%B0%E5%BC%8F%E3%81%A7%E3%81%AE%E8%87%AA%E4%BD%9C%E3%82%92%E4%BD%BF%E3%81%84%E5%88%86%E3%81%91%E3%82%8B%EF%BC%81%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/23948/" rel="bookmark"> <h3 class="module-article-item-title">Excelで必ず覚えておきたい「関数10種」。合計、カウント、四捨五入、文字列連結、表引きなどが自由自在に！【エクセル時短】</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2024/04/ex-jitan206-00-n-thumb-180xauto-74019.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2024-04-03T21:30:00+09:00">21:30 2024.04.03</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=Excel%E3%81%A7%E5%BF%85%E3%81%9A%E8%A6%9A%E3%81%88%E3%81%A6%E3%81%8A%E3%81%8D%E3%81%9F%E3%81%84%E3%80%8C%E9%96%A2%E6%95%B010%E7%A8%AE%E3%80%8D%E3%80%82%E5%90%88%E8%A8%88%E3%80%81%E3%82%AB%E3%82%A6%E3%83%B3%E3%83%88%E3%80%81%E5%9B%9B%E6%8D%A8%E4%BA%94%E5%85%A5%E3%80%81%E6%96%87%E5%AD%97%E5%88%97%E9%80%A3%E7%B5%90%E3%80%81%E8%A1%A8%E5%BC%95%E3%81%8D%E3%81%AA%E3%81%A9%E3%81%8C%E8%87%AA%E7%94%B1%E8%87%AA%E5%9C%A8%E3%81%AB%EF%BC%81%E3%80%90%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E6%99%82%E7%9F%AD%E3%80%91%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F23948%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F23948%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/23948/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/23948/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F23948%2F&title=Excel%E3%81%A7%E5%BF%85%E3%81%9A%E8%A6%9A%E3%81%88%E3%81%A6%E3%81%8A%E3%81%8D%E3%81%9F%E3%81%84%E3%80%8C%E9%96%A2%E6%95%B010%E7%A8%AE%E3%80%8D%E3%80%82%E5%90%88%E8%A8%88%E3%80%81%E3%82%AB%E3%82%A6%E3%83%B3%E3%83%88%E3%80%81%E5%9B%9B%E6%8D%A8%E4%BA%94%E5%85%A5%E3%80%81%E6%96%87%E5%AD%97%E5%88%97%E9%80%A3%E7%B5%90%E3%80%81%E8%A1%A8%E5%BC%95%E3%81%8D%E3%81%AA%E3%81%A9%E3%81%8C%E8%87%AA%E7%94%B1%E8%87%AA%E5%9C%A8%E3%81%AB%EF%BC%81%E3%80%90%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E6%99%82%E7%9F%AD%E3%80%91%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/4429/" rel="bookmark"> <h3 class="module-article-item-title">Excel関数機能別一覧（全510関数）</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2018/10/ogp_exkansu-thumb-180xauto-47142.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2024-03-21T21:00:00+09:00">21:00 2024.03.21</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=Excel%E9%96%A2%E6%95%B0%20%E6%A9%9F%E8%83%BD%E5%88%A5%E4%B8%80%E8%A6%A7%EF%BC%88%E5%85%A8510%E9%96%A2%E6%95%B0%EF%BC%89%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F4429%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F4429%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/4429/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/4429/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F4429%2F&title=Excel%E9%96%A2%E6%95%B0%20%E6%A9%9F%E8%83%BD%E5%88%A5%E4%B8%80%E8%A6%A7%EF%BC%88%E5%85%A8510%E9%96%A2%E6%95%B0%EF%BC%89%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/24729/" rel="bookmark"> <h3 class="module-article-item-title">Excelのセル内で改行する方法。任意の位置で改行するキー操作から関数を使った挿入・削除テクニックまで</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/11/ex-jitan220-00-thumb-180xauto-72567.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-11-28T06:00:00+09:00">06:00 2023.11.28</time></p> <p><a href="/category/windows-office/excel/">Excel</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=Excel%E3%81%AE%E3%82%BB%E3%83%AB%E5%86%85%E3%81%A7%E6%94%B9%E8%A1%8C%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95%E3%80%82%E4%BB%BB%E6%84%8F%E3%81%AE%E4%BD%8D%E7%BD%AE%E3%81%A7%E6%94%B9%E8%A1%8C%E3%81%99%E3%82%8B%E3%82%AD%E3%83%BC%E6%93%8D%E4%BD%9C%E3%81%8B%E3%82%89%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E3%81%A3%E3%81%9F%E6%8C%BF%E5%85%A5%E3%83%BB%E5%89%8A%E9%99%A4%E3%83%86%E3%82%AF%E3%83%8B%E3%83%83%E3%82%AF%E3%81%BE%E3%81%A7%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F24729%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F24729%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/24729/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/24729/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F24729%2F&title=Excel%E3%81%AE%E3%82%BB%E3%83%AB%E5%86%85%E3%81%A7%E6%94%B9%E8%A1%8C%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95%E3%80%82%E4%BB%BB%E6%84%8F%E3%81%AE%E4%BD%8D%E7%BD%AE%E3%81%A7%E6%94%B9%E8%A1%8C%E3%81%99%E3%82%8B%E3%82%AD%E3%83%BC%E6%93%8D%E4%BD%9C%E3%81%8B%E3%82%89%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E3%81%A3%E3%81%9F%E6%8C%BF%E5%85%A5%E3%83%BB%E5%89%8A%E9%99%A4%E3%83%86%E3%82%AF%E3%83%8B%E3%83%83%E3%82%AF%E3%81%BE%E3%81%A7%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/19816/" rel="bookmark"> <h3 class="module-article-item-title">COUNTIFS関数の使い方</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/10/20231012_o0200-thumb-180xauto-72223.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-10-12T15:30:00+09:00">15:30 2023.10.12</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=COUNTIFS%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F19816%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F19816%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/19816/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/19816/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F19816%2F&title=COUNTIFS%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/19807/" rel="bookmark"> <h3 class="module-article-item-title">COUNTIF関数の使い方</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/10/20231012_o0100-thumb-180xauto-72222.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-10-12T15:00:00+09:00">15:00 2023.10.12</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=COUNTIF%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F19807%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F19807%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/19807/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/19807/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F19807%2F&title=COUNTIF%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/24480/" rel="bookmark"> <h3 class="module-article-item-title">TODAY関数とNOW関数の使い方</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/08/ex-jitan216-00-thumb-180xauto-71872.png" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-09-04T06:00:00+09:00">06:00 2023.09.04</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=TODAY%E9%96%A2%E6%95%B0%E3%81%A8NOW%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F24480%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F24480%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/24480/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/24480/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F24480%2F&title=TODAY%E9%96%A2%E6%95%B0%E3%81%A8NOW%E9%96%A2%E6%95%B0%E3%81%AE%E4%BD%BF%E3%81%84%E6%96%B9%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/4392/" rel="bookmark"> <h3 class="module-article-item-title">TODAY関数／NOW関数 - 現在の日付と時刻を求める</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/09/ogp_today_now_202309-thumb-180xauto-71912.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-09-01T21:30:00+09:00">21:30 2023.09.01</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=TODAY%E9%96%A2%E6%95%B0%EF%BC%8FNOW%E9%96%A2%E6%95%B0%20-%20%E7%8F%BE%E5%9C%A8%E3%81%AE%E6%97%A5%E4%BB%98%E3%81%A8%E6%99%82%E5%88%BB%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F4392%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F4392%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/4392/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/4392/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F4392%2F&title=TODAY%E9%96%A2%E6%95%B0%EF%BC%8FNOW%E9%96%A2%E6%95%B0%20-%20%E7%8F%BE%E5%9C%A8%E3%81%AE%E6%97%A5%E4%BB%98%E3%81%A8%E6%99%82%E5%88%BB%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/4366/" rel="bookmark"> <h3 class="module-article-item-title">SUBTOTAL関数 - さまざまな集計値を求める</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/08/ogp_subtotal_202308-thumb-180xauto-71821.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-09-01T20:00:00+09:00">20:00 2023.09.01</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=SUBTOTAL%E9%96%A2%E6%95%B0%20-%20%E3%81%95%E3%81%BE%E3%81%96%E3%81%BE%E3%81%AA%E9%9B%86%E8%A8%88%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F4366%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F4366%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/4366/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/4366/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F4366%2F&title=SUBTOTAL%E9%96%A2%E6%95%B0%20-%20%E3%81%95%E3%81%BE%E3%81%96%E3%81%BE%E3%81%AA%E9%9B%86%E8%A8%88%E5%80%A4%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/4367/" rel="bookmark"> <h3 class="module-article-item-title">AGGREGATE関数 - さまざまな集計値、順位や分位数を求める</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/08/ogp_aggregate_202308-thumb-180xauto-71826.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-09-01T20:00:00+09:00">20:00 2023.09.01</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=AGGREGATE%E9%96%A2%E6%95%B0%20-%20%E3%81%95%E3%81%BE%E3%81%96%E3%81%BE%E3%81%AA%E9%9B%86%E8%A8%88%E5%80%A4%E3%80%81%E9%A0%86%E4%BD%8D%E3%82%84%E5%88%86%E4%BD%8D%E6%95%B0%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F4367%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F4367%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/4367/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/4367/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F4367%2F&title=AGGREGATE%E9%96%A2%E6%95%B0%20-%20%E3%81%95%E3%81%BE%E3%81%96%E3%81%BE%E3%81%AA%E9%9B%86%E8%A8%88%E5%80%A4%E3%80%81%E9%A0%86%E4%BD%8D%E3%82%84%E5%88%86%E4%BD%8D%E6%95%B0%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/4513/" rel="bookmark"> <h3 class="module-article-item-title">COUNTIF関数で条件に一致するデータの個数を求める</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/08/ogp_countif_202308-thumb-180xauto-71827.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-08-29T17:00:00+09:00">17:00 2023.08.29</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=COUNTIF%E9%96%A2%E6%95%B0%E3%81%A7%E6%9D%A1%E4%BB%B6%E3%81%AB%E4%B8%80%E8%87%B4%E3%81%99%E3%82%8B%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E5%80%8B%E6%95%B0%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F4513%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F4513%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/4513/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/4513/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F4513%2F&title=COUNTIF%E9%96%A2%E6%95%B0%E3%81%A7%E6%9D%A1%E4%BB%B6%E3%81%AB%E4%B8%80%E8%87%B4%E3%81%99%E3%82%8B%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E5%80%8B%E6%95%B0%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/4514/" rel="bookmark"> <h3 class="module-article-item-title">COUNTIFS関数 - 複数の条件に一致するデータの個数を求める</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/08/ogp_countifs_202308-thumb-180xauto-71825.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-08-29T17:00:00+09:00">17:00 2023.08.29</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=COUNTIFS%E9%96%A2%E6%95%B0%20-%20%E8%A4%87%E6%95%B0%E3%81%AE%E6%9D%A1%E4%BB%B6%E3%81%AB%E4%B8%80%E8%87%B4%E3%81%99%E3%82%8B%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E5%80%8B%E6%95%B0%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F4514%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F4514%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/4514/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/4514/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F4514%2F&title=COUNTIFS%E9%96%A2%E6%95%B0%20-%20%E8%A4%87%E6%95%B0%E3%81%AE%E6%9D%A1%E4%BB%B6%E3%81%AB%E4%B8%80%E8%87%B4%E3%81%99%E3%82%8B%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E5%80%8B%E6%95%B0%E3%82%92%E6%B1%82%E3%82%81%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/14598/" rel="bookmark"> <h3 class="module-article-item-title">MAXIFS関数 - 複数の条件に対応する範囲の中から最大値を返す</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/08/ogp_maxifs_202308-thumb-180xauto-71823.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-08-29T17:00:00+09:00">17:00 2023.08.29</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=MAXIFS%E9%96%A2%E6%95%B0%20-%20%E8%A4%87%E6%95%B0%E3%81%AE%E6%9D%A1%E4%BB%B6%E3%81%AB%E5%AF%BE%E5%BF%9C%E3%81%99%E3%82%8B%E7%AF%84%E5%9B%B2%E3%81%AE%E4%B8%AD%E3%81%8B%E3%82%89%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E8%BF%94%E3%81%99%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F14598%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F14598%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/14598/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/14598/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F14598%2F&title=MAXIFS%E9%96%A2%E6%95%B0%20-%20%E8%A4%87%E6%95%B0%E3%81%AE%E6%9D%A1%E4%BB%B6%E3%81%AB%E5%AF%BE%E5%BF%9C%E3%81%99%E3%82%8B%E7%AF%84%E5%9B%B2%E3%81%AE%E4%B8%AD%E3%81%8B%E3%82%89%E6%9C%80%E5%A4%A7%E5%80%A4%E3%82%92%E8%BF%94%E3%81%99%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/4145/" rel="bookmark"> <h3 class="module-article-item-title">SUMIF関数 - 条件を指定して数値を合計する</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/08/ogp_sumif_202308-thumb-180xauto-71824.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-08-29T17:00:00+09:00">17:00 2023.08.29</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=SUMIF%E9%96%A2%E6%95%B0%20-%20%E6%9D%A1%E4%BB%B6%E3%82%92%E6%8C%87%E5%AE%9A%E3%81%97%E3%81%A6%E6%95%B0%E5%80%A4%E3%82%92%E5%90%88%E8%A8%88%E3%81%99%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F4145%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F4145%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/4145/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/4145/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F4145%2F&title=SUMIF%E9%96%A2%E6%95%B0%20-%20%E6%9D%A1%E4%BB%B6%E3%82%92%E6%8C%87%E5%AE%9A%E3%81%97%E3%81%A6%E6%95%B0%E5%80%A4%E3%82%92%E5%90%88%E8%A8%88%E3%81%99%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/4358/" rel="bookmark"> <h3 class="module-article-item-title">SUM関数 - 数値を合計する</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/08/ogp_sum_202308-thumb-180xauto-71828.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-08-29T17:00:00+09:00">17:00 2023.08.29</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=SUM%E9%96%A2%E6%95%B0%20-%20%E6%95%B0%E5%80%A4%E3%82%92%E5%90%88%E8%A8%88%E3%81%99%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F4358%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F4358%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/4358/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/4358/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F4358%2F&title=SUM%E9%96%A2%E6%95%B0%20-%20%E6%95%B0%E5%80%A4%E3%82%92%E5%90%88%E8%A8%88%E3%81%99%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/4365/" rel="bookmark"> <h3 class="module-article-item-title">SUMIFS関数 - 複数の条件を指定して数値を合計する</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/08/ogp_sumifs_202308-thumb-180xauto-71829.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-08-29T17:00:00+09:00">17:00 2023.08.29</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=SUMIFS%E9%96%A2%E6%95%B0%20-%20%E8%A4%87%E6%95%B0%E3%81%AE%E6%9D%A1%E4%BB%B6%E3%82%92%E6%8C%87%E5%AE%9A%E3%81%97%E3%81%A6%E6%95%B0%E5%80%A4%E3%82%92%E5%90%88%E8%A8%88%E3%81%99%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F4365%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F4365%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/4365/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/4365/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F4365%2F&title=SUMIFS%E9%96%A2%E6%95%B0%20-%20%E8%A4%87%E6%95%B0%E3%81%AE%E6%9D%A1%E4%BB%B6%E3%82%92%E6%8C%87%E5%AE%9A%E3%81%97%E3%81%A6%E6%95%B0%E5%80%A4%E3%82%92%E5%90%88%E8%A8%88%E3%81%99%E3%82%8B%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/4509/" rel="bookmark"> <h3 class="module-article-item-title">TEXT関数 - 数値に表示形式を適用した文字列を返す</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/08/ogp_text_202308-thumb-180xauto-71830.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-08-29T17:00:00+09:00">17:00 2023.08.29</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=TEXT%E9%96%A2%E6%95%B0%20-%20%E6%95%B0%E5%80%A4%E3%81%AB%E8%A1%A8%E7%A4%BA%E5%BD%A2%E5%BC%8F%E3%82%92%E9%81%A9%E7%94%A8%E3%81%97%E3%81%9F%E6%96%87%E5%AD%97%E5%88%97%E3%82%92%E8%BF%94%E3%81%99%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F4509%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F4509%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/4509/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/4509/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F4509%2F&title=TEXT%E9%96%A2%E6%95%B0%20-%20%E6%95%B0%E5%80%A4%E3%81%AB%E8%A1%A8%E7%A4%BA%E5%BD%A2%E5%BC%8F%E3%82%92%E9%81%A9%E7%94%A8%E3%81%97%E3%81%9F%E6%96%87%E5%AD%97%E5%88%97%E3%82%92%E8%BF%94%E3%81%99%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> <div class="module-article-item"> <div class="module-article-item-header"> <a href="/article/14285/" rel="bookmark"> <h3 class="module-article-item-title">IFS関数 - 複数の条件を順に調べた結果に応じて異なる値を返す</h3> <div class="module-article-item-image"> <img src="https://dekiru.net/assets_c/2023/08/ogp_ifs_202308-thumb-180xauto-71822.jpg" width="180" height="95" alt="" decoding="async" loading="lazy" /> </div> </a> </div> <div class="module-article-item-meta"> <p><time datetime="2023-08-29T17:00:00+09:00">17:00 2023.08.29</time></p> <p><a href="/category/windows-office/excel-kansu/">Excel関数</a></p> </div> <div class="module-article-item-share"> <dl> <dt> <button class="module-article-item-share-btn role-article-item-share-btn"> <i class="material-icons" aria-hidden="true">share</i><span class="module-hidden">記事をシェアする</span> </button> </dt> <dd> <ul> <li><a href="https://twitter.com/intent/tweet?text=IFS%E9%96%A2%E6%95%B0%20-%20%E8%A4%87%E6%95%B0%E3%81%AE%E6%9D%A1%E4%BB%B6%E3%82%92%E9%A0%86%E3%81%AB%E8%AA%BF%E3%81%B9%E3%81%9F%E7%B5%90%E6%9E%9C%E3%81%AB%E5%BF%9C%E3%81%98%E3%81%A6%E7%95%B0%E3%81%AA%E3%82%8B%E5%80%A4%E3%82%92%E8%BF%94%E3%81%99%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88&url=https%3A%2F%2Fdekiru.net%2Farticle%2F14285%2F&via=dekirunet" target="_blank" rel="nofollow"><i class="fab fa-twitter" aria-hidden="true"></i><span class="module-hidden">Twitterでシェア</span></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fdekiru.net%2Farticle%2F14285%2F" target="_blank" rel="nofollow"><i class="fab fa-facebook" aria-hidden="true"></i><span class="module-hidden">Facebookでシェア</span></a></li> <li><a href="https://social-plugins.line.me/lineit/share?url=https://dekiru.net/article/14285/" target="_blank" rel="nofollow"><i class="module-icon-line" aria-hidden="true"></i><span class="module-hidden">LINEで送る</span></a></li> <li><a href="https://b.hatena.ne.jp/entry/https://dekiru.net/article/14285/" target="_blank" rel="nofollow"><i class="module-icon-hateb" aria-hidden="true"></i><span class="module-hidden">はてなブックマークに追加</span></a></li> <li><a href="https://getpocket.com/edit?url=https%3A%2F%2Fdekiru.net%2Farticle%2F14285%2F&title=IFS%E9%96%A2%E6%95%B0%20-%20%E8%A4%87%E6%95%B0%E3%81%AE%E6%9D%A1%E4%BB%B6%E3%82%92%E9%A0%86%E3%81%AB%E8%AA%BF%E3%81%B9%E3%81%9F%E7%B5%90%E6%9E%9C%E3%81%AB%E5%BF%9C%E3%81%98%E3%81%A6%E7%95%B0%E3%81%AA%E3%82%8B%E5%80%A4%E3%82%92%E8%BF%94%E3%81%99%20-%20%E3%81%A7%E3%81%8D%E3%82%8B%E3%83%8D%E3%83%83%E3%83%88" target="_blank" rel="nofollow"><i class="fab fa-get-pocket"></i><span class="module-hidden">Pocketに追加</span></a></li> </ul> </dd> </dl> </div> </div> </div> <div class="module-paging-nav"> <ul class="pagination-navi"><li><span>1</span></li><li><a href="/category/windows-office/excel-kansu/index_2.shtml">2</a></li><li><a href="/category/windows-office/excel-kansu/index_3.shtml">3</a></li><li><a href="/category/windows-office/excel-kansu/index_4.shtml">4</a></li><li><a href="/category/windows-office/excel-kansu/index_5.shtml">5</a></li></ul> </div> </div> </div> <div class="block-ads"> <aside>  <div id="div-gpt-ad-all-list_catebanner02"> <script> googletag.cmd.push(function() { googletag.display('div-gpt-ad-all-list_catebanner02'); }); </script> </div> </aside> </div> <div class="block-pickup-banner-area"> <div class="module-pickup-banner-area-inner"> <div class="module-pickup-banner-area-header"> <div class="module-pickup-banner-area-header-inner"> <h2 class="module-pickup-banner-area-title"><span>ピックアップ</span></h2> </div> </div> <div class="module-pickup-banner-area-body"> <ul> <li><a href="/article/24919/"><img src="/feature/images/bnr_line_2.png" width="300" alt="LINEビジネス活用公式ガイド"></a></li> <li><a href="/article/22304/"><img src="/feature/images/bnr_office2021_1.jpg" width="300" alt="Office 2021特集"></a></li> <li><a href="/article/4429/"><img src="/feature/images/Ex_kansu_2.png" width="300" alt="Excel関数510"></a></li> </ul> </div> </div> </div> </main> </div> <div class="block-float-menu-search" id="role-float-menu-search"> <div class="module-search"> <button class="module-header-menu-btn-search-close role-header-menu-btn-search-close"> <i class="material-icons" aria-hidden="true">close</i><span class="module-hidden">検索メニューを閉じる</span> </button> <dl> <dt><i class="material-icons" aria-hidden="true">search</i>検索</dt> <dd> <form class="module-search-form" method="get" action="/s/" role="search"> <fieldset> <legend accesskey="s">サイト内検索</legend> <input class="module-search-box" type="search" name="q" value="" placeholder="使い方が知りたいソフト名や機種名を入力" tabindex="1" accesskey="1" /><button class="module-search-btn" type="submit" name="sa" tabindex="2" accesskey="2"><i class="material-icons" aria-hidden="true">search</i><span class="module-hidden">検索</span></button> </fieldset> </form> <div class="module-search-keywords"> <dl> <dt><span class="module-search-keywords-label">急上昇ワード</span></dt> <dd> <ul><li><a href="/s/?q=iPhone">iPhone</a></li><li><a href="/s/?q=Googleマップ">Googleマップ</a></li><li><a href="/s/?q=VLOOKUP">VLOOKUP</a></li></ul> </dd> </dl> </div> </dd> </dl> <button class="module-header-menu-btn-search-close-txt role-header-menu-btn-search-close" aria-label="検索メニューを閉じる"> <i class="material-icons" aria-hidden="true">close</i><span>閉じる</span> </button> </div> </div> <div class="block-float-menu-category" id="role-float-menu-category"> <div class="module-list-category"> <button class="module-header-menu-btn-category-close role-header-menu-btn-category-close"> <i class="material-icons" aria-hidden="true">close</i><span class="module-hidden">カテゴリー一覧を閉じる</span> </button> <nav> <dl> <dt><i class="material-icons" aria-hidden="true">format_list_bulleted</i>カテゴリーから探す</dt> <dd> <ul> <li class="module-link-top-page"><a href="/"><i class="fas fa-angle-right fa-lg" aria-hidden="true"></i>トップページ</a></li> <li><a href="/category/series/">連載</a><ul><li><a href="/category/series/excel-qa/">Excel Q&A</a></li><li><a href="/category/series/toianna/">トイアンナ流仕事術</a></li><li><a href="/category/series/powerautomate/">PowerAutomateではじめる業務の完全自動化</a></li><li><a href="/category/series/ai/">AI議事録作成術</a></li><li><a href="/category/series/windows-11-qa/">Windows 11 Q&A</a></li><li><a href="/category/series/teams-fumikomi/">Teams踏み込み活用術</a></li><li><a href="/category/series/excel-rule/">Excel講師の仕事術</a></li><li><a href="/category/series/excel-jitan/">エクセル時短</a></li><li><a href="/category/series/powerpoint-jitan/">パワポ時短</a></li><li><a href="/category/series/windows-tips/">Windows Tips</a></li><li><a href="/category/series/perori-trip/">神保町ペロリ旅</a></li><li><a href="/category/series/orenomercari/">俺のメルカリ</a></li><li class="role-disable-item"><a href="/category/series/pc-shigoto-1/">パソコン仕事術</a></li><li class="role-disable-item"><a href="/category/series/cat/">マインクラフトプログラミング入門</a></li><li class="role-disable-item"><a href="/category/series/oyako-youtuber/">親子でユーチューバー</a></li><li class="role-disable-item"><a href="/category/series/soumu-excel/">総務のExcel</a></li></ul><li><a href="/category/yomerunet/">読めるネット（書籍全文公開）</a><ul><li><a href="/category/yomerunet/line-business-katsuyou-v2/">LINEビジネス活用公式ガイド第2版</a></li><li><a href="/category/yomerunet/line-business-katsuyou/">LINEビジネス活用公式ガイド</a></li><li><a href="/category/yomerunet/dekirugyakubiki-google-analytics-v2/">できる逆引き Googleアナリティクス</a></li><li><a href="/category/yomerunet/slack-digital-shift/">Slackデジタルシフト</a></li><li><a href="/category/yomerunet/saikyo-no-datakeiei/">最強のデータ経営</a></li></ul><li><a href="/category/windows-office/">Windows/Office</a><ul><li><a href="/category/windows-office/windows-11/">Windows 11</a></li><li><a href="/category/windows-office/windows-10/">Windows 10</a></li><li><a href="/category/windows-office/word/">Word</a></li><li><a href="/category/windows-office/excel/">Excel</a></li><li><a href="/category/windows-office/excel-kansu/">Excel関数</a></li><li><a href="/category/windows-office/powerpoint/">PowerPoint</a></li><li><a href="/category/windows-office/teams/">Microsoft Teams</a></li><li><a href="/category/windows-office/outlook/">Outlook</a></li><li class="role-disable-item"><a href="/category/windows-office/office/">Office全般</a></li><li><a href="/category/windows-office/onenote/">OneNote</a></li><li class="role-disable-item"><a href="/category/windows-office/access/">Access</a></li><li class="role-disable-item"><a href="/category/windows-office/onedrive/">OneDrive</a></li><li><a href="/category/windows-office/powertoys/">PowerToys</a></li><li class="role-disable-item"><a href="/category/windows-office/windows-8/">Windows 8.1/8</a></li><li class="role-disable-item"><a href="/category/windows-office/windows-7/">Windows 7</a></li><li class="role-disable-item"><a href="/category/windows-office/windows-xp/">XPサポート終了</a></li><li class="role-disable-item"><a href="/category/windows-office/etc/">その他（Windows/Office）</a></li></ul><li><a href="/category/apple/">Apple</a><ul><li><a href="/category/apple/iphone/">iPhone</a></li><li><a href="/category/apple/ipad/">iPad</a></li><li class="role-disable-item"><a href="/category/apple/apple-music/">Apple Music</a></li><li class="role-disable-item"><a href="/category/apple/apple-watch/">Apple Watch</a></li><li class="role-disable-item"><a href="/category/apple/ipod-touch/">iPod touch</a></li><li class="role-disable-item"><a href="/category/apple/apple-tv/">Apple TV</a></li><li class="role-disable-item"><a href="/category/apple/imovie/">iMovie</a></li><li class="role-disable-item"><a href="/category/apple/iphoto/">iPhoto</a></li><li class="role-disable-item"><a href="/category/apple/mac/">Mac</a></li><li class="role-disable-item"><a href="/category/apple/itunes/">iTunes</a></li><li class="role-disable-item"><a href="/category/apple/etc/">その他（Apple）</a></li></ul><li><a href="/category/google/">Google</a><ul><li><a href="/category/google/android/">Androidスマートフォン</a></li><li><a href="/category/google/chromebook/">Chromebook</a></li><li><a href="/category/google/chrome/">Chrome</a></li><li><a href="/category/google/gmail/">Gmail</a></li><li><a href="/category/google/google-meet/">Google Meet</a></li><li><a href="/category/google/google-calendar/">Googleカレンダー</a></li><li><a href="/category/google/google-sheets/">Googleスプレッドシート</a></li><li><a href="/category/google/google-drive/">Googleドライブ</a></li><li><a href="/category/google/google-translate/">Google翻訳</a></li><li><a href="/category/google/google-map/">Googleマップ</a></li><li><a href="/category/google/google-photos/">Googleフォト</a></li><li><a href="/category/google/google-analytics/">Googleアナリティクス</a></li><li><a href="/category/google/google-datastudio/">Googleデータポータル</a></li><li><a href="/category/google/google-form/">Googleフォーム</a></li><li class="role-disable-item"><a href="/category/google/google-tagmanager/">Googleタグマネージャ</a></li><li class="role-disable-item"><a href="/category/google/google-search/">Google検索</a></li><li class="role-disable-item"><a href="/category/google/google-play-music/">Google Playミュージック</a></li><li class="role-disable-item"><a href="/category/google/google-todo/">Google ToDoリスト</a></li><li class="role-disable-item"><a href="/category/google/google-adsense/">Google AdSense</a></li><li class="role-disable-item"><a href="/category/google/inbox/">Inbox by Gmail</a></li><li class="role-disable-item"><a href="/category/google/ingress/">Ingress（イングレス）</a></li><li class="role-disable-item"><a href="/category/google/etc/">その他（Google）</a></li></ul><li><a href="/category/service-software/">サービス／ソフト</a><ul><li><a href="/category/service-software/generative-ai/">生成AI</a></li><li><a href="/category/service-software/chatgpt/">ChatGPT</a></li><li><a href="/category/service-software/discord/">Discord</a></li><li><a href="/category/service-software/steam/">Steam</a></li><li><a href="/category/service-software/line/">LINE</a></li><li><a href="/category/service-software/youtube/">YouTube</a></li><li><a href="/category/service-software/amazon/">Amazon</a></li><li><a href="/category/service-software/paypay/">PayPay</a></li><li><a href="/category/service-software/facebook/">Facebook</a></li><li><a href="/category/service-software/instagram/">Instagram</a></li><li><a href="/category/service-software/zoom/">Zoom</a></li><li><a href="/category/service-software/slack/">Slack</a></li><li><a href="/category/service-software/uipath/">UiPath</a></li><li><a href="/category/service-software/audible/">Audible</a></li><li><a href="/category/service-software/minecraft/">マインクラフト</a></li><li><a href="/category/service-software/nengajyo/">年賀状</a></li><li class="role-disable-item"><a href="/category/service-software/line-entry/">LINE entry</a></li><li class="role-disable-item"><a href="/category/service-software/photoshop/">Photoshop</a></li><li class="role-disable-item"><a href="/category/service-software/premierepro/">Premiere Pro</a></li><li class="role-disable-item"><a href="/category/service-software/scratch/">Scratch</a></li><li class="role-disable-item"><a href="/category/service-software/pokemon-go/">Pokémon GO（ポケモンGO）</a></li><li class="role-disable-item"><a href="/category/service-software/spotify/">Spotify</a></li><li class="role-disable-item"><a href="/category/service-software/giftel/">giftel（ギフテル）</a></li><li class="role-disable-item"><a href="/category/service-software/programming/">プログラミング</a></li><li class="role-disable-item"><a href="/category/service-software/website-service/">Webサイト／Webサービス</a></li><li class="role-disable-item"><a href="/category/service-software/video-streaming/">動画配信サービス</a></li><li class="role-disable-item"><a href="/category/service-software/dropbox/">Dropbox</a></li><li class="role-disable-item"><a href="/category/service-software/evernote/">Evernote</a></li><li class="role-disable-item"><a href="/category/service-software/shortcut-key/">ショートカットキー</a></li><li class="role-disable-item"><a href="/category/service-software/note-mu/">note（note.mu）</a></li><li class="role-disable-item"><a href="/category/service-software/pdf/">PDF</a></li><li class="role-disable-item"><a href="/category/service-software/ganref/">GANREF</a></li><li class="role-disable-item"><a href="/category/service-software/cloud/">クラウド</a></li><li class="role-disable-item"><a href="/category/service-software/firefox/">Firefox</a></li><li class="role-disable-item"><a href="/category/service-software/iknow/">iKnow!</a></li><li class="role-disable-item"><a href="/category/service-software/rosetta-stone/">Rosetta Stone</a></li><li class="role-disable-item"><a href="/category/service-software/rss-reader/">RSSリーダー</a></li><li class="role-disable-item"><a href="/category/service-software/twitter/">X（旧Twitter）</a></li><li class="role-disable-item"><a href="/category/service-software/ustream/">Ustream</a></li><li class="role-disable-item"><a href="/category/service-software/search/">検索</a></li><li class="role-disable-item"><a href="/category/service-software/cybozu-live/">サイボウズLive</a></li><li class="role-disable-item"><a href="/category/service-software/second-life/">セカンドライフ</a></li><li class="role-disable-item"><a href="/category/service-software/hatena-bookmark/">はてなブックマーク</a></li><li class="role-disable-item"><a href="/category/service-software/blog-pearts/">ブログパーツ</a></li><li class="role-disable-item"><a href="/category/service-software/kowaza/">今週の小ワザ</a></li><li class="role-disable-item"><a href="/category/service-software/etc/">その他（サービス／ソフト）</a></li></ul><li class="role-disable-item"><a href="/category/web-production/">サイト制作・運営</a><ul><li><a href="/category/web-production/html/">HTML</a></li><li><a href="/category/web-production/css/">CSS</a></li><li><a href="/category/web-production/web-marketing/">Webマーケティング</a></li><li><a href="/category/web-production/heatmap/">ヒートマップツール</a></li><li><a href="/category/web-production/wordpress/">WordPress（ワードプレス）</a></li></ul><li><a href="/category/device/">デバイス</a><ul><li><a href="/category/device/atomcam/">ATOM Cam</a></li><li><a href="/category/device/amazon-echo/">Amazon Echo</a></li><li><a href="/category/device/nintendo-switch/">ニンテンドースイッチ</a></li><li class="role-disable-item"><a href="/category/device/sim-free/">格安スマホ、格安SIM</a></li><li class="role-disable-item"><a href="/category/device/kids-gps/">子供GPS</a></li><li class="role-disable-item"><a href="/category/device/home-security/">ホームセキュリティ</a></li><li class="role-disable-item"><a href="/category/device/cat1048/">スマートスピーカー</a></li><li class="role-disable-item"><a href="/category/device/usb-memory/">USBメモリー</a></li><li class="role-disable-item"><a href="/category/device/gopro/">GoPro</a></li><li class="role-disable-item"><a href="/category/device/chromecast/">Chromecast</a></li><li class="role-disable-item"><a href="/category/device/mamolook/">まもるっく</a></li><li class="role-disable-item"><a href="/category/device/home-alsok/">HOME ALSOK</a></li><li class="role-disable-item"><a href="/category/device/dynabook/">dynabook</a></li><li class="role-disable-item"><a href="/category/device/touch-diamond/">Touch Diamond</a></li><li class="role-disable-item"><a href="/category/device/pocket-wifi/">Pocket WiFi</a></li><li class="role-disable-item"><a href="/category/device/blackberry/">BlackBerry</a></li><li class="role-disable-item"><a href="/category/device/vaio/">VAIO</a></li><li class="role-disable-item"><a href="/category/device/mini-note-pc/">ミニノートPC</a></li><li class="role-disable-item"><a href="/category/device/etc/">その他（デバイス）</a></li></ul><li class="role-disable-item"><a href="/category/android/">Android</a><ul><li class="role-disable-item"><a href="/category/android/galaxy/">GALAXY</a></li><li class="role-disable-item"><a href="/category/android/lg/">LG（G2、Optimus）</a></li><li class="role-disable-item"><a href="/category/android/medias/">MEDIAS</a></li><li class="role-disable-item"><a href="/category/android/lifetouch-note/">LifeTouch NOTE</a></li><li class="role-disable-item"><a href="/category/android/sony-tablet-s/">Sony Tablet S</a></li><li class="role-disable-item"><a href="/category/android/apps/">Androidアプリ・活用術</a></li><li class="role-disable-item"><a href="/category/android/etc/">その他（Android）</a></li></ul><li class="role-disable-item"><a href="/category/carrier/">通信事業者</a><ul><li><a href="/category/carrier/ahamo/">ahamo</a></li><li><a href="/category/carrier/ntt-docomo/">NTTドコモ</a></li><li><a href="/category/carrier/au-kddi/">au</a></li><li><a href="/category/carrier/softbank-mobile/">ソフトバンク</a></li></ul><li><a href="/category/reading/">読み物</a><ul><li><a href="/category/reading/30/">できる30周年リレーコラム</a></li><li><a href="/category/reading/25/">できる25周年リレーコラム</a></li><li><a href="/category/reading/topics/">トピック</a></li><li><a href="/category/reading/telework/">テレワーク</a></li><li><a href="/category/reading/tokyo2020/">東京オリンピック</a></li><li class="role-disable-item"><a href="/category/reading/dekirumonn/">できるもんの部屋</a></li><li><a href="/category/reading/mindfulness/">マインドフルネス</a></li><li class="role-disable-item"><a href="/category/reading/matome/">まとめ</a></li><li class="role-disable-item"><a href="/category/reading/interview/">インタビュー</a></li><li class="role-disable-item"><a href="/category/reading/etc/">その他（読み物）</a></li></ul><li><a href="/category/editors/">編集部から</a><ul><li><a href="/category/editors/information/">お知らせ</a></li><li><a href="/category/editors/tokuten/">読者特典</a></li></ul> </ul> </dd> </dl> </nav> <button class="module-header-menu-btn-category-close-txt role-header-menu-btn-category-close" aria-label="カテゴリー一覧を閉じる"> <i class="material-icons" aria-hidden="true">close</i><span>閉じる</span> </button> </div> </div> <div class="block-page-footer -no-footer-ads"> <footer> <div class="module-page-footer-inner"> <div class="module-go-pagetop"> <p> <a href="#top"> <i aria-hidden="true"> <svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" width="24" height="24" stroke="currentColor"> <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M5 10l7-7m0 0l7 7m-7-7v18" /> </svg> </i><span class="module-hidden">ページ上部へ</span> </a> </p> </div> <div class="module-page-footer-sns-list"> <div class="module-page-footer-sns-list-header"> <h2 class="module-page-footer-sns-list-title"> <span class="module-page-footer-sns-list-title-en module-txt-upp" lang="en">Follow Me</span> <span class="module-page-footer-sns-list-title-jp">フォローして通知を受け取る</span> </h2> </div> <div class="module-page-footer-sns-list-body"> <ul> <li><a href="https://twitter.com/dekirunet/" target="_blank"> <span class="module-page-footer-sns-list-label-icon"> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 1200 1227" fill="none" height="48" aria-hidden="true"> <path d="M714.163 519.284L1160.89 0H1055.03L667.137 450.887L357.328 0H0L468.492 681.821L0 1226.37H105.866L515.491 750.218L842.672 1226.37H1200L714.137 519.284H714.163ZM569.165 687.828L521.697 619.934L144.011 79.6944H306.615L611.412 515.685L658.88 583.579L1055.08 1150.3H892.476L569.165 687.854V687.828Z" fill="#000000" /> </svg> </span> <span class="module-page-footer-sns-list-label module-txt-upp">X</span></a></li> <li><a href="https://www.facebook.com/dekirunet" target="_blank"><span class="module-page-footer-sns-list-label-icon"><i class="fab fa-facebook" aria-hidden="true"></i></span><span class="module-page-footer-sns-list-label module-txt-upp">Facebook</span></a></li> <li><a href="https://www.youtube.com/user/dekirunet" target="_blank"><span class="module-page-footer-sns-list-label-icon"><i class="fab fa-youtube" aria-hidden="true"></i></span><span class="module-page-footer-sns-list-label module-txt-upp">YouTube</span></a></li> </ul> </div> </div> <div class="module-page-footer-link"> <div class="module-page-footer-link-inner"> <div class="module-page-footer-link-list"> <dl> <dt>できるシリーズ</dt> <dd> <ul> <li><a href="/dekiru/"><i class="fas fa-angle-right" aria-hidden="true"></i>できるシリーズについて</a></li> <li><a href="/30th/" target="_blank"><i class="fas fa-angle-right" aria-hidden="true"></i>30周年特設サイト</a></li> <li><a href="/pdfdownload/"><i class="fas fa-angle-right" aria-hidden="true"></i>読者限定PDFのダウンロード</a></li> <li><a href="/sampledownload/"><i class="fas fa-angle-right" aria-hidden="true"></i>サンプルファイルのダウンロード</a></li> </ul> </dd> </dl> <dl> <dt>できるネット</dt> <dd> <ul> <li><a href="/about/"><i class="fas fa-angle-right" aria-hidden="true"></i>できるネットについて</a></li> <li><a href="/contact/"><i class="fas fa-angle-right" aria-hidden="true"></i>広告掲載などのお問い合わせ</a></li> <li><a href="/all/"><i class="fas fa-angle-right" aria-hidden="true"></i>全記事一覧</a></li> </ul> </dd> </dl> </div> </div> </div> <div class="module-page-footer-link-bottom"> <div class="module-page-footer-link-bottom-inner"> <div class="module-page-footer-site-inner-link"> <ul> <li><a href="http://www.impress.co.jp/privacy_policy/" target="_blank"><i class="fas fa-angle-right" aria-hidden="true"></i>プライバシーポリシー</a></li> <li><a href="http://www.impress.co.jp/profile/" target="_blank"><i class="fas fa-angle-right" aria-hidden="true"></i>会社概要</a></li> <li><a href="http://www.impressholdings.com/" target="_blank"><i class="fas fa-angle-right" aria-hidden="true"></i>インプレスグループ</a></li> </ul> </div> <div class="module-page-footer-impress-link"> <dl> <dt>インプレスの書籍情報サイト&ニュースメディア</dt> <dd> <ul> <li><a href="https://book.impress.co.jp/" target="_blank"><i class="fas fa-angle-right" aria-hidden="true"></i>インプレスブックス</a></li> <li><a href="https://www.watch.impress.co.jp/" target="_blank"><i class="fas fa-angle-right" aria-hidden="true"></i>Impress Watch</a></li> </ul> </dd> </dl> </div> <div class="module-page-footer-impress-logo-link"> <p><a href="http://www.impress.co.jp/" target="_blank"><img src="/static/v2018/img/impress-logo.svg" alt="インプレス" /></a></p> </div> <div class="module-copyright"> <p><small>Copyright ©<script>document.write(new Date().getFullYear());</script> Impress Corporation. All rights reserved.</small></p> </div> </div> </div> </div> </footer> </div> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script> $(function() { $('a[href*="#"]:not([href="#"])').click(function() { if (location.pathname.replace(/^\//,'') == this.pathname.replace(/^\//,'') && location.hostname == this.hostname) { var target = $(this.hash); target = target.length ? target : $('[name=' + this.hash.slice(1) +']'); if (target.length) { $('html, body').animate({ scrollTop: target.offset().top }, 400); return false; } } }); }); </script> <script> $(function(){ $('.role-article-item-share-btn').click(function(){ $(this).toggleClass('state-open'); $(this).parents('.module-article-item-share').toggleClass('state-open'); }); $('#role-header-menu-btn-category').click(function(){ $('#role-float-menu-category').addClass('state-open'); $('body').addClass('state-menu-open'); }); $('.role-header-menu-btn-category-close').click(function(){ $('#role-float-menu-category').removeClass('state-open'); $('body').removeClass('state-menu-open'); }); $('#role-header-menu-btn-search').click(function(){ $('#role-float-menu-search').addClass('state-open'); $('body').addClass('state-menu-open'); $('input.module-search-box').focus(); }); $('.role-header-menu-btn-search-close').click(function(){ $('#role-float-menu-search').removeClass('state-open'); $('body').removeClass('state-menu-open'); }); }); </script> <script> googletag.cmd.push(function() { googletag.pubads().refresh([gptAdSlots[2], gptAdSlots[3]]); }); </script> </body> </html>

CINXE.COM

Excel関数 使い方解説一覧 | できるネット

Excel関数使い方解説一覧 | できるネット