VLOOKUPで合計は不可→SUMIF関数を使う

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

跑龙套的企鹅 · 男篮世界杯中国VS新西兰年初八东莞开波-香港商報· 3 月前 ·

含蓄的木耳 · 优秀毕业生事迹（三）千里之行，始于足下-黑龙 ...· 3 月前 ·

刚毅的酱牛肉 · Vue3.0 前的 TypeScript ...· 3 月前 ·

千杯不醉的牙膏 · 南方周末· 1 年前 ·

乐观的跑步机 · 空间中三维矢量（Vectors in 3D ...· 2 年前 ·

</noscript><div id="st-ami"><div id="wrapper" class=""><div id="wrapper-in"><header id=""><div id="header-full"><div id="headbox-bg"><div id="headbox"><nav id="s-navi" class="pcnone" data-st-nav="" data-st-nav-type="normal"><dl class="acordion is-active" data-st-nav-primary=""><dt class="trigger"><p class="acordion_button"><span class="op op-menu has-text"><i class="st-fa st-svg-menu"/></span></p><div id="st-mobile-logo"/><p class="acordion_extra_1"><a href="https://pcacademy.jp/contact-2"><span class="op-st"><i class="st-fa fa-envelope" aria-hidden="true"/><span class="op-text">メールする</span></span></a></p><p class="acordion_extra_2"><a href="tel:0120508350"><span class="op-st2"><i class="st-fa fa-phone" aria-hidden="true"/><span class="op-text">電話する</span></span></a></p></dt><dd class="acordion_tree"><div class="acordion_tree_content"><div class="menu-%e3%82%b9%e3%83%9e%e3%83%9b%e3%83%9f%e3%83%89%e3%83%ab-container"><ul id="menu-%e3%82%b9%e3%83%9e%e3%83%9b%e3%83%9f%e3%83%89%e3%83%ab" class="menu"><li id="menu-item-21799" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-home menu-item-21799"><a href="https://pcacademy.jp/"><span class="menu-item-label">ホーム</span></a></li><li id="menu-item-21833" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-21833"><a href="https://pcacademy.jp/service"><span class="menu-item-label">講座案内</span></a></li><li id="menu-item-29170" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-29170"><a href="https://pcacademy.jp/shop"><span class="menu-item-label">店舗一覧</span></a></li><li id="menu-item-21802" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-21802"><a href="https://pcacademy.jp/voiceschool"><span class="menu-item-label">生徒さんの声</span></a></li><li id="menu-item-29264" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-29264"><a href="https://pcacademy.jp/test"><span class="menu-item-label">各種試験申込</span></a></li><li id="menu-item-55454" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-55454"><a href="https://pcacademy.jp/yoyaku"><span class="menu-item-label">レッスン予約</span></a></li></ul></div><div class="clear"/></div></dd></dl></nav><div id="header-l"><div id="st-text-logo"><p class="sitename sitename-only"><a href="https://pcacademy.jp/"> <noscript><img class="sitename-only-img" alt="パソコン教室パレハ" src="https://pcacademy.jp/wp-content/uploads/2020/09/fc6be47382e11ef79f700ee2c9b5e53d.png"/></noscript><img class="lazyload sitename-only-img" alt="パソコン教室パレハ" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2020/09/fc6be47382e11ef79f700ee2c9b5e53d.png"/> </a></p></div></div><div id="header-r" class="smanone"><div id="text-3" class="headbox widget_text"><div class="textwidget"><div class="st-margin" style="margin: 14px 0 0 0;"><span class="st-mybtn st-mybtn-mini"><a style="background:#c4302b;border-radius:5px;font-weight:normal;color:#fff;box-shadow:0 3px 0 #f44336;" href="https://pcacademy.jp/contact-2"><i class="st-fa fa-envelope-o st-css-no" aria-hidden="true"/>お問い合わせ<i class="st-fa fa-after fa-angle-right st-css-no" aria-hidden="true"/></a></span><span class="st-mybtn st-mybtn-mini"><a style="background:#c4302b;border-radius:5px;font-weight:normal;color:#fff;box-shadow:0 3px 0 #f44336;" href="tel:0120-50-8350"><i class="st-fa fa-volume-control-phone st-css-no" aria-hidden="true"/>フリーダイヤル<i class="st-fa fa-after fa-angle-right st-css-no" aria-hidden="true"/></a></span><span class="st-mybtn st-mybtn-mini"><a style="background:#556b2f;border-radius:5px;font-weight:normal;color:#fff;box-shadow:0 3px 0 #8BC34A;" href="https://www.youtube.com/channel/UC6zyaoBtDdkHe5fF0Ufs5IQ" rel="nofollow"><i class="st-fa fa-pencil st-css-no" aria-hidden="true"/>Youtube動画<i class="st-fa fa-after fa-angle-right st-css-no" aria-hidden="true"/></a></span><span class="st-mybtn st-mybtn-mini"><a style="background:#556b2f;border-radius:5px;font-weight:normal;color:#fff;box-shadow:0 3px 0 #8BC34A;" href="https://pcacademy.jp/blog"><i class="st-fa fa-pencil st-css-no" aria-hidden="true"/>パソコン情報　<i class="st-fa fa-after fa-angle-right st-css-no" aria-hidden="true"/></a></span></div></div></div></div></div></div><div id="gazou-wide"><div id="st-menubox"><div id="st-menuwide"><nav class="smanone clearfix"><ul id="menu-%e6%96%b0menu" class="menu"><li id="menu-item-21679" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-home menu-item-21679"><a href="https://pcacademy.jp/">ホーム</a></li><li id="menu-item-28598" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-28598"><a href="https://pcacademy.jp/shop">店舗一覧</a></li><li id="menu-item-8876" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-8876"><a href="https://pcacademy.jp/service">講座案内</a></li><li id="menu-item-21794" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-21794"><a href="https://pcacademy.jp/voiceschool">生徒さんの声</a></li><li id="menu-item-29263" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-29263"><a href="https://pcacademy.jp/test">各種試験申込</a></li><li id="menu-item-28599" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-28599"><a href="https://pcacademy.jp/contact-2">お問い合わせ</a></li></ul></nav></div></div><div id="st-headerbox"><div id="st-header"/></div></div></div></header><div id="content-w"><div id="st-header-post-under-box" class="st-header-post-no-data " style=""><div class="st-dark-cover"/></div><div id="content" class="clearfix"><div id="contentInner"><main><article><div id="post-61042" class="st-post post-61042 post type-post status-publish format-standard has-post-thumbnail hentry category-columnexcel"><div id="breadcrumb"><ol itemscope="" itemtype="http://schema.org/BreadcrumbList"><li itemprop="itemListElement" itemscope="" itemtype="http://schema.org/ListItem"> <a href="https://pcacademy.jp" itemprop="item"> <span itemprop="name">HOME</span> </a> &gt;<meta itemprop="position" content="1"/></li><li itemprop="itemListElement" itemscope="" itemtype="http://schema.org/ListItem"> <a href="https://pcacademy.jp/category/columnexcel" itemprop="item"> <span itemprop="name">エクセル・VBA</span> </a> &gt;<meta itemprop="position" content="2"/></li></ol></div><p class="st-catgroup"> <a href="https://pcacademy.jp/category/columnexcel" title="View all posts in エクセル・VBA" rel="category tag"><span class="catname st-catid105">エクセル・VBA</span></a></p><h1 class="entry-title">VLOOKUPで合計は不可→SUMIF関数を使う</h1><div class="blogbox "><p><span class="kdate"> <i class="st-fa st-svg-refresh"/><time class="updated" datetime="2023-06-11T17:08:32+0900">2023年6月11日</time> </span></p></div><div class="mainbox"><div id="nocopy"><div class="entry-content"><p/><noscript><img decoding="async" class="size-medium wp-image-61046 aligncenter" src="https://pcacademy.jp/wp-content/uploads/2023/02/1-20-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" srcset="https://pcacademy.jp/wp-content/uploads/2023/02/1-20-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/1-20-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/1-20-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/1-20.jpg 737w" sizes="(max-width: 640px) 100vw, 640px"/></noscript><img decoding="async" class="lazyload size-medium wp-image-61046 aligncenter" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20640%20640%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/02/1-20-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/02/1-20-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/1-20-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/1-20-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/1-20.jpg 737w" data-sizes="(max-width: 640px) 100vw, 640px"/><p>今回の記事はExcel(エクセル)｜VLOOKUPで合計を出す方法についてお話します。</p><div class="st-slidebox-c is-collapsed " style="margin-bottom:20px;" data-st-slidebox=""><p class="st-btn-open" data-st-slidebox-toggle="" style="color:#1a1a1a;"><span class="st-slidebox-btn-text" data-st-slidebox-text="" data-st-slidebox-text-collapsed="+ 習得しておきたいVLOOKUP関数のテクニックはこちらをクリックして下さい" data-st-slidebox-text-expanded="閉じる">+ 習得しておきたいVLOOKUP関数のテクニックはこちらをクリックして下さい</span></p><div class="st-slidebox" data-st-slidebox-content=""><p><a href="https://pcacademy.jp/excel-vlookup-multiple-conditions">Excel(エクセル)｜VLOOKUP関数で複数条件を指定する方法</a></p><p><a href="https://pcacademy.jp/excel-vlookup-range">VLOOKUPで範囲の選び方を徹底解説｜固定や名前の定義</a></p><p><a href="https://pcacademy.jp/excel-vlookup-line">Excel(エクセル)｜VLOOKUPで行がうまくいかない時はHLOOKUPを使う</a></p><p><a href="https://pcacademy.jp/excel-separate-file">Excel(エクセル)｜VLOOKUP関数で別ファイルからデータを参照する方法</a></p><p><a href="https://pcacademy.jp/excel-vlookup-if-multiple-conditions">Excel(エクセル)｜VLOOKUP関数とIF関数を使って複数条件を設定する方法</a></p><p><a href="https://pcacademy.jp/excel-vlookup-perfect-matching">Excel(エクセル)｜VLOOKUPで完全一致の使い方</a></p><p><a href="https://pcacademy.jp/excel-vlookup-approximation">Excel(エクセル)｜VLOOKUP関数で近似値の使い方</a></p><p><a href="https://pcacademy.jp/excel-vlookup-if-multiple-conditions">Excel(エクセル)｜VLOOKUP関数とIF関数を使って複数条件を設定する方法</a></p><p><a href="https://pcacademy.jp/excel-vlookup-wildcard-partial-match">VLOOKUP関数でワイルドカードで部分一致させる方法</a></p><p><a href="https://pcacademy.jp/excel-separate-file">Excel(エクセル)｜VLOOKUP関数で別ファイルからデータを参照する方法</a></p><p><a href="https://pcacademy.jp/excel-vlookup-multiple-conditions">Excel(エクセル)｜VLOOKUP関数で複数条件を指定する方法</a></p><p><a href="https://pcacademy.jp/excel-vlookup-line">Excel(エクセル)｜VLOOKUPで行がうまくいかない時はHLOOKUPを使う</a></p><p><a href="https://pcacademy.jp/excel-vlookup-blank">Excel(エクセル)｜VLOOKUP関数でエラーを返さず空白で返す方法</a></p><p><a href="https://pcacademy.jp/excel-vlookup-table">VLOOKUPでテーブルを使用して効率よく参照する方法</a></p><p><a href="https://pcacademy.jp/excel-vlookup-spreadsheet">GoogleスプレッドシートでVLOOKUPを使う方法</a></p><p><a href="https://pcacademy.jp/excel-vlookup-total">VLOOKUPで合計は不可→SUMIF関数を使う</a></p><p><a href="https://pcacademy.jp/excel-retrieval-method">Excel(エクセル)｜VLOOKUPの検索方法って何を入れるの？</a></p><p><a href="https://pcacademy.jp/excel-vlookup-column-index">Excel(エクセル)｜VLOOKUPで自動で列番号を取得する方法</a></p><p><a href="https://pcacademy.jp/excel-vlookup-range">VLOOKUPで範囲の選び方を徹底解説｜固定や名前の定義</a></p><p><a href="https://pcacademy.jp/excel-vlookup-search-value">Excel(エクセル)｜VLOOKUPの検索値を徹底解説！このコツを押さえればもう大丈夫！</a></p><p><a href="https://pcacademy.jp/excel-vlookup-error">Excel(エクセル)｜VLOOKUP関数でエラーが出たときの対処法</a></p><p><a href="https://pcacademy.jp/excel-vlookup-separate-sheet">Excel(エクセル)｜VLOOKUP関数で別シートを参照する方法</a></p></div></div><p><a href="https://pcacademy.jp/online-lesson"><noscript><img decoding="async" class="size-medium wp-image-52742 aligncenter" src="https://pcacademy.jp/wp-content/uploads/2022/09/260ab025b372552e7679d1a3bc425019-640x350.jpg" alt="苦手な方専門のパソコン教室" width="640" height="350" srcset="https://pcacademy.jp/wp-content/uploads/2022/09/260ab025b372552e7679d1a3bc425019-640x350.jpg 640w, https://pcacademy.jp/wp-content/uploads/2022/09/260ab025b372552e7679d1a3bc425019-768x420.jpg 768w, https://pcacademy.jp/wp-content/uploads/2022/09/260ab025b372552e7679d1a3bc425019.jpg 968w" sizes="(max-width: 640px) 100vw, 640px"/></noscript><img decoding="async" class="lazyload size-medium wp-image-52742 aligncenter" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20640%20350%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2022/09/260ab025b372552e7679d1a3bc425019-640x350.jpg" alt="苦手な方専門のパソコン教室" width="640" height="350" data-srcset="https://pcacademy.jp/wp-content/uploads/2022/09/260ab025b372552e7679d1a3bc425019-640x350.jpg 640w, https://pcacademy.jp/wp-content/uploads/2022/09/260ab025b372552e7679d1a3bc425019-768x420.jpg 768w, https://pcacademy.jp/wp-content/uploads/2022/09/260ab025b372552e7679d1a3bc425019.jpg 968w" data-sizes="(max-width: 640px) 100vw, 640px"/></a></p><div class="st-h-ad"><div class="aicp"> </div></div><h2>VLOOKUP関数を使って合計は出せる？</h2><p/><noscript><img decoding="async" class="aligncenter size-full wp-image-61516" src="https://pcacademy.jp/wp-content/uploads/2023/03/146415ccfe9f73c9ba9610b41c566bc7.jpg" alt="VLOOKUP合計の説明" width="737" height="737" srcset="https://pcacademy.jp/wp-content/uploads/2023/03/146415ccfe9f73c9ba9610b41c566bc7.jpg 737w, https://pcacademy.jp/wp-content/uploads/2023/03/146415ccfe9f73c9ba9610b41c566bc7-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/146415ccfe9f73c9ba9610b41c566bc7-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/03/146415ccfe9f73c9ba9610b41c566bc7-100x100.jpg 100w" sizes="(max-width: 737px) 100vw, 737px"/></noscript><img decoding="async" class="lazyload aligncenter size-full wp-image-61516" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20737%20737%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/03/146415ccfe9f73c9ba9610b41c566bc7.jpg" alt="VLOOKUP合計の説明" width="737" height="737" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/03/146415ccfe9f73c9ba9610b41c566bc7.jpg 737w, https://pcacademy.jp/wp-content/uploads/2023/03/146415ccfe9f73c9ba9610b41c566bc7-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/146415ccfe9f73c9ba9610b41c566bc7-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/03/146415ccfe9f73c9ba9610b41c566bc7-100x100.jpg 100w" data-sizes="(max-width: 737px) 100vw, 737px"/><p>結論、VLOOKUP関数で合計を出すことはできません。</p><p>考えようによっては、IF関数とVLOOKUP関数、SUM関数を組み合わせればできそうですが…。</p><p>VLOOKUP関数は、検索値を元に列番号を指定して自動でデータを取得する関数であって、取り出したデータを元に合計を出すことはできません。</p><p>条件に合ったデータを探して合計を出したい場合は、VLOOKUP関数ではなく「SUMIF関数」を使用しましょう。</p><p>SUMIF関数の使い方について紹介します。</p><div class="st-h-ad"><div class="aicp"> </div></div><h2>条件に合った合計はSUMIF関数　画像解説</h2><p/><noscript><img decoding="async" class="size-medium wp-image-61047 aligncenter" src="https://pcacademy.jp/wp-content/uploads/2023/02/2-21-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" srcset="https://pcacademy.jp/wp-content/uploads/2023/02/2-21-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/2-21-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/2-21-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/2-21.jpg 737w" sizes="(max-width: 640px) 100vw, 640px"/></noscript><img decoding="async" class="lazyload size-medium wp-image-61047 aligncenter" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20640%20640%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/02/2-21-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/02/2-21-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/2-21-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/2-21-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/2-21.jpg 737w" data-sizes="(max-width: 640px) 100vw, 640px"/><p/><noscript><img decoding="async" class="size-medium wp-image-61048 aligncenter" src="https://pcacademy.jp/wp-content/uploads/2023/02/3-23-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" srcset="https://pcacademy.jp/wp-content/uploads/2023/02/3-23-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/3-23-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/3-23-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/3-23.jpg 737w" sizes="(max-width: 640px) 100vw, 640px"/></noscript><img decoding="async" class="lazyload size-medium wp-image-61048 aligncenter" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20640%20640%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/02/3-23-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/02/3-23-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/3-23-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/3-23-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/3-23.jpg 737w" data-sizes="(max-width: 640px) 100vw, 640px"/><p/><noscript><img decoding="async" class="size-medium wp-image-61049 aligncenter" src="https://pcacademy.jp/wp-content/uploads/2023/02/4-21-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" srcset="https://pcacademy.jp/wp-content/uploads/2023/02/4-21-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/4-21-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/4-21-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/4-21.jpg 737w" sizes="(max-width: 640px) 100vw, 640px"/></noscript><img decoding="async" class="lazyload size-medium wp-image-61049 aligncenter" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20640%20640%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/02/4-21-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/02/4-21-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/4-21-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/4-21-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/4-21.jpg 737w" data-sizes="(max-width: 640px) 100vw, 640px"/><p/><noscript><img decoding="async" class="size-medium wp-image-61050 aligncenter" src="https://pcacademy.jp/wp-content/uploads/2023/02/5-21-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" srcset="https://pcacademy.jp/wp-content/uploads/2023/02/5-21-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/5-21-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/5-21-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/5-21.jpg 737w" sizes="(max-width: 640px) 100vw, 640px"/></noscript><img decoding="async" class="lazyload size-medium wp-image-61050 aligncenter" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20640%20640%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/02/5-21-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/02/5-21-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/5-21-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/5-21-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/5-21.jpg 737w" data-sizes="(max-width: 640px) 100vw, 640px"/><p/><noscript><img decoding="async" class="size-medium wp-image-61051 aligncenter" src="https://pcacademy.jp/wp-content/uploads/2023/02/6-21-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" srcset="https://pcacademy.jp/wp-content/uploads/2023/02/6-21-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/6-21-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/6-21-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/6-21.jpg 737w" sizes="(max-width: 640px) 100vw, 640px"/></noscript><img decoding="async" class="lazyload size-medium wp-image-61051 aligncenter" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20640%20640%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/02/6-21-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/02/6-21-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/6-21-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/6-21-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/6-21.jpg 737w" data-sizes="(max-width: 640px) 100vw, 640px"/><p/><noscript><img decoding="async" class="size-medium wp-image-61052 aligncenter" src="https://pcacademy.jp/wp-content/uploads/2023/02/7-20-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" srcset="https://pcacademy.jp/wp-content/uploads/2023/02/7-20-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/7-20-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/7-20-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/7-20.jpg 737w" sizes="(max-width: 640px) 100vw, 640px"/></noscript><img decoding="async" class="lazyload size-medium wp-image-61052 aligncenter" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20640%20640%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/02/7-20-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/02/7-20-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/7-20-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/7-20-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/7-20.jpg 737w" data-sizes="(max-width: 640px) 100vw, 640px"/><p/><noscript><img decoding="async" class="size-medium wp-image-61053 aligncenter" src="https://pcacademy.jp/wp-content/uploads/2023/02/8-16-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" srcset="https://pcacademy.jp/wp-content/uploads/2023/02/8-16-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/8-16-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/8-16-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/8-16.jpg 737w" sizes="(max-width: 640px) 100vw, 640px"/></noscript><img decoding="async" class="lazyload size-medium wp-image-61053 aligncenter" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20640%20640%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/02/8-16-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/02/8-16-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/8-16-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/8-16-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/8-16.jpg 737w" data-sizes="(max-width: 640px) 100vw, 640px"/><p/><noscript><img decoding="async" class="size-medium wp-image-61054 aligncenter" src="https://pcacademy.jp/wp-content/uploads/2023/02/9-12-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" srcset="https://pcacademy.jp/wp-content/uploads/2023/02/9-12-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/9-12-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/9-12-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/9-12.jpg 737w" sizes="(max-width: 640px) 100vw, 640px"/></noscript><img decoding="async" class="lazyload size-medium wp-image-61054 aligncenter" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20640%20640%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/02/9-12-640x640.jpg" alt="Excel(エクセル)｜VLOOKUPで合計は不可→SUMIF関数を使う" width="640" height="640" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/02/9-12-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/9-12-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/9-12-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/9-12.jpg 737w" data-sizes="(max-width: 640px) 100vw, 640px"/><div class="st-h-ad"><div class="aicp"> </div></div><h2>条件に合った合計を求める方法</h2><p>VLOOKUP関数で合計を求めることはできませんので、SUMIF関数を使った下記の方法で条件に一致した合計を求めましょう。</p><h3>SUMIF関数の構文はこちら</h3><div class="yellowbox"><p><span class="huto" style="font-size: 120%;">=SUMIF(範囲,検索条件,合計範囲)</span></p></div><p>=SUMIF(<span class="ymarker">範囲</span>,<span class="rmarker">検索条件</span>,<span class="bmarker">合計範囲</span>)</p><p><span class="ymarker">この範囲の中から</span>、<span class="rmarker">この条件に合うものを見つけて</span>、<span class="bmarker">この範囲から合計出してね</span></p><p>という物になります。</p><p/><noscript><img decoding="async" class="aligncenter size-full wp-image-61519" src="https://pcacademy.jp/wp-content/uploads/2023/03/4e7ea00a461be6595952868f3ebb2057.jpg" alt="VLOOKUP関数で合計の説明" width="1130" height="679" srcset="https://pcacademy.jp/wp-content/uploads/2023/03/4e7ea00a461be6595952868f3ebb2057.jpg 1130w, https://pcacademy.jp/wp-content/uploads/2023/03/4e7ea00a461be6595952868f3ebb2057-640x385.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/4e7ea00a461be6595952868f3ebb2057-1024x615.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/4e7ea00a461be6595952868f3ebb2057-768x461.jpg 768w" sizes="(max-width: 1130px) 100vw, 1130px"/></noscript><img decoding="async" class="lazyload aligncenter size-full wp-image-61519" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%201130%20679%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/03/4e7ea00a461be6595952868f3ebb2057.jpg" alt="VLOOKUP関数で合計の説明" width="1130" height="679" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/03/4e7ea00a461be6595952868f3ebb2057.jpg 1130w, https://pcacademy.jp/wp-content/uploads/2023/03/4e7ea00a461be6595952868f3ebb2057-640x385.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/4e7ea00a461be6595952868f3ebb2057-1024x615.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/4e7ea00a461be6595952868f3ebb2057-768x461.jpg 768w" data-sizes="(max-width: 1130px) 100vw, 1130px"/><p>今回は、上記の例で解説します。</p><p>合計金額の欄に、各商品ごとの売上金額を求めます。</p><p> </p><p/><noscript><img decoding="async" class="aligncenter size-full wp-image-61520" src="https://pcacademy.jp/wp-content/uploads/2023/03/4d4f9204fb6f4a4af7fed10a12fd0a21.jpg" alt="VLOOKUP関数で合計の説明" width="1411" height="735" srcset="https://pcacademy.jp/wp-content/uploads/2023/03/4d4f9204fb6f4a4af7fed10a12fd0a21.jpg 1411w, https://pcacademy.jp/wp-content/uploads/2023/03/4d4f9204fb6f4a4af7fed10a12fd0a21-640x333.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/4d4f9204fb6f4a4af7fed10a12fd0a21-1024x533.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/4d4f9204fb6f4a4af7fed10a12fd0a21-768x400.jpg 768w" sizes="(max-width: 1411px) 100vw, 1411px"/></noscript><img decoding="async" class="lazyload aligncenter size-full wp-image-61520" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%201411%20735%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/03/4d4f9204fb6f4a4af7fed10a12fd0a21.jpg" alt="VLOOKUP関数で合計の説明" width="1411" height="735" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/03/4d4f9204fb6f4a4af7fed10a12fd0a21.jpg 1411w, https://pcacademy.jp/wp-content/uploads/2023/03/4d4f9204fb6f4a4af7fed10a12fd0a21-640x333.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/4d4f9204fb6f4a4af7fed10a12fd0a21-1024x533.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/4d4f9204fb6f4a4af7fed10a12fd0a21-768x400.jpg 768w" data-sizes="(max-width: 1411px) 100vw, 1411px"/><p>まず、合計を求めたいセルにSUMIF関数を挿入します。</p><p> </p><p/><noscript><img decoding="async" class="aligncenter size-full wp-image-61521" src="https://pcacademy.jp/wp-content/uploads/2023/03/79a7d2cc912990f8fab6726b402f8966.jpg" alt="VLOOKUP関数で合計の説明" width="1414" height="733" srcset="https://pcacademy.jp/wp-content/uploads/2023/03/79a7d2cc912990f8fab6726b402f8966.jpg 1414w, https://pcacademy.jp/wp-content/uploads/2023/03/79a7d2cc912990f8fab6726b402f8966-640x332.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/79a7d2cc912990f8fab6726b402f8966-1024x531.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/79a7d2cc912990f8fab6726b402f8966-768x398.jpg 768w" sizes="(max-width: 1414px) 100vw, 1414px"/></noscript><img decoding="async" class="lazyload aligncenter size-full wp-image-61521" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%201414%20733%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/03/79a7d2cc912990f8fab6726b402f8966.jpg" alt="VLOOKUP関数で合計の説明" width="1414" height="733" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/03/79a7d2cc912990f8fab6726b402f8966.jpg 1414w, https://pcacademy.jp/wp-content/uploads/2023/03/79a7d2cc912990f8fab6726b402f8966-640x332.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/79a7d2cc912990f8fab6726b402f8966-1024x531.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/79a7d2cc912990f8fab6726b402f8966-768x398.jpg 768w" data-sizes="(max-width: 1414px) 100vw, 1414px"/><p>続いて、「範囲」選択します。</p><p>範囲は、次に指定する条件を探したい範囲になります。</p><p>今回は最終的に、数式を他のセルにコピーするので、ここで指定した範囲は絶対参照で固定します。</p><p> </p><p/><noscript><img decoding="async" class="aligncenter size-full wp-image-61522" src="https://pcacademy.jp/wp-content/uploads/2023/03/5624d4a26855d64abaf808b027d5eb4b.jpg" alt="VLOOKUP関数で合計の説明" width="1411" height="732" srcset="https://pcacademy.jp/wp-content/uploads/2023/03/5624d4a26855d64abaf808b027d5eb4b.jpg 1411w, https://pcacademy.jp/wp-content/uploads/2023/03/5624d4a26855d64abaf808b027d5eb4b-640x332.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/5624d4a26855d64abaf808b027d5eb4b-1024x531.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/5624d4a26855d64abaf808b027d5eb4b-768x398.jpg 768w" sizes="(max-width: 1411px) 100vw, 1411px"/></noscript><img decoding="async" class="lazyload aligncenter size-full wp-image-61522" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%201411%20732%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/03/5624d4a26855d64abaf808b027d5eb4b.jpg" alt="VLOOKUP関数で合計の説明" width="1411" height="732" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/03/5624d4a26855d64abaf808b027d5eb4b.jpg 1411w, https://pcacademy.jp/wp-content/uploads/2023/03/5624d4a26855d64abaf808b027d5eb4b-640x332.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/5624d4a26855d64abaf808b027d5eb4b-1024x531.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/5624d4a26855d64abaf808b027d5eb4b-768x398.jpg 768w" data-sizes="(max-width: 1411px) 100vw, 1411px"/><p>次に、先ほど選択した範囲から検索したい条件を選択します。</p><p>直接条件を入力しても良いですが、セル参照で行うと便利です。</p><p> </p><p/><noscript><img decoding="async" class="aligncenter size-full wp-image-61523" src="https://pcacademy.jp/wp-content/uploads/2023/03/f10c17203ad5081dfb3caef6db9e5041.jpg" alt="VLOOKUP関数で合計の説明" width="1411" height="732" srcset="https://pcacademy.jp/wp-content/uploads/2023/03/f10c17203ad5081dfb3caef6db9e5041.jpg 1411w, https://pcacademy.jp/wp-content/uploads/2023/03/f10c17203ad5081dfb3caef6db9e5041-640x332.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/f10c17203ad5081dfb3caef6db9e5041-1024x531.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/f10c17203ad5081dfb3caef6db9e5041-768x398.jpg 768w" sizes="(max-width: 1411px) 100vw, 1411px"/></noscript><img decoding="async" class="lazyload aligncenter size-full wp-image-61523" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%201411%20732%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/03/f10c17203ad5081dfb3caef6db9e5041.jpg" alt="VLOOKUP関数で合計の説明" width="1411" height="732" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/03/f10c17203ad5081dfb3caef6db9e5041.jpg 1411w, https://pcacademy.jp/wp-content/uploads/2023/03/f10c17203ad5081dfb3caef6db9e5041-640x332.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/f10c17203ad5081dfb3caef6db9e5041-1024x531.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/f10c17203ad5081dfb3caef6db9e5041-768x398.jpg 768w" data-sizes="(max-width: 1411px) 100vw, 1411px"/><p>最後に、合計金額を出すために計算したいセル範囲を選択します。</p><p>こちらも、絶対参照で固定しておきましょう。</p><p>あとは、Enterキーを押して関数を確定させます。</p><p> </p><p/><noscript><img decoding="async" class="aligncenter size-full wp-image-61524" src="https://pcacademy.jp/wp-content/uploads/2023/03/4179789df548f7821ea84c7e20d3eecb.jpg" alt="VLOOKUP関数で合計の説明" width="1128" height="681" srcset="https://pcacademy.jp/wp-content/uploads/2023/03/4179789df548f7821ea84c7e20d3eecb.jpg 1128w, https://pcacademy.jp/wp-content/uploads/2023/03/4179789df548f7821ea84c7e20d3eecb-640x386.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/4179789df548f7821ea84c7e20d3eecb-1024x618.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/4179789df548f7821ea84c7e20d3eecb-768x464.jpg 768w" sizes="(max-width: 1128px) 100vw, 1128px"/></noscript><img decoding="async" class="lazyload aligncenter size-full wp-image-61524" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%201128%20681%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/03/4179789df548f7821ea84c7e20d3eecb.jpg" alt="VLOOKUP関数で合計の説明" width="1128" height="681" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/03/4179789df548f7821ea84c7e20d3eecb.jpg 1128w, https://pcacademy.jp/wp-content/uploads/2023/03/4179789df548f7821ea84c7e20d3eecb-640x386.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/4179789df548f7821ea84c7e20d3eecb-1024x618.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/4179789df548f7821ea84c7e20d3eecb-768x464.jpg 768w" data-sizes="(max-width: 1128px) 100vw, 1128px"/><p>これで結果を求めることができます。</p><p> </p><p/><noscript><img decoding="async" class="aligncenter size-full wp-image-61525" src="https://pcacademy.jp/wp-content/uploads/2023/03/09345f338100cc9e7931bdaefc5922b3.jpg" alt="VLOOKUP関数で合計の説明" width="1132" height="683" srcset="https://pcacademy.jp/wp-content/uploads/2023/03/09345f338100cc9e7931bdaefc5922b3.jpg 1132w, https://pcacademy.jp/wp-content/uploads/2023/03/09345f338100cc9e7931bdaefc5922b3-640x386.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/09345f338100cc9e7931bdaefc5922b3-1024x618.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/09345f338100cc9e7931bdaefc5922b3-768x463.jpg 768w" sizes="(max-width: 1132px) 100vw, 1132px"/></noscript><img decoding="async" class="lazyload aligncenter size-full wp-image-61525" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%201132%20683%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/03/09345f338100cc9e7931bdaefc5922b3.jpg" alt="VLOOKUP関数で合計の説明" width="1132" height="683" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/03/09345f338100cc9e7931bdaefc5922b3.jpg 1132w, https://pcacademy.jp/wp-content/uploads/2023/03/09345f338100cc9e7931bdaefc5922b3-640x386.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/03/09345f338100cc9e7931bdaefc5922b3-1024x618.jpg 1024w, https://pcacademy.jp/wp-content/uploads/2023/03/09345f338100cc9e7931bdaefc5922b3-768x463.jpg 768w" data-sizes="(max-width: 1132px) 100vw, 1132px"/><p>あとは、下のセルにも数式をコピーしたら完成です。</p><p>範囲と、合計範囲は絶対参照で固定、検索条件は相対参照なので、正しい結果を表示することができます。</p><p> </p><p><a href="https://pcacademy.jp/online-lesson"><noscript><img decoding="async" class="size-medium wp-image-52741 aligncenter" src="https://pcacademy.jp/wp-content/uploads/2022/09/e0ab449471f3e5f32bfca6299d0c0b0e-640x350.jpg" alt="苦手な方専門のパソコン教室" width="640" height="350" srcset="https://pcacademy.jp/wp-content/uploads/2022/09/e0ab449471f3e5f32bfca6299d0c0b0e-640x350.jpg 640w, https://pcacademy.jp/wp-content/uploads/2022/09/e0ab449471f3e5f32bfca6299d0c0b0e-768x420.jpg 768w, https://pcacademy.jp/wp-content/uploads/2022/09/e0ab449471f3e5f32bfca6299d0c0b0e.jpg 968w" sizes="(max-width: 640px) 100vw, 640px"/></noscript><img decoding="async" class="lazyload size-medium wp-image-52741 aligncenter" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20640%20350%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2022/09/e0ab449471f3e5f32bfca6299d0c0b0e-640x350.jpg" alt="苦手な方専門のパソコン教室" width="640" height="350" data-srcset="https://pcacademy.jp/wp-content/uploads/2022/09/e0ab449471f3e5f32bfca6299d0c0b0e-640x350.jpg 640w, https://pcacademy.jp/wp-content/uploads/2022/09/e0ab449471f3e5f32bfca6299d0c0b0e-768x420.jpg 768w, https://pcacademy.jp/wp-content/uploads/2022/09/e0ab449471f3e5f32bfca6299d0c0b0e.jpg 968w" data-sizes="(max-width: 640px) 100vw, 640px"/></a></p><p><a href="https://line.me/R/ti/p/%40956hbkkc" rel="nofollow"><noscript><img decoding="async" class="aligncenter wp-image-43255 size-full" src="https://pcacademy.jp/wp-content/uploads/2022/01/25ea687e316356ce147a87d8725fb48a.gif" alt="パソコン教室パレハのライン登録" width="529" height="454"/></noscript><img decoding="async" class="lazyload aligncenter wp-image-43255 size-full" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20529%20454%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2022/01/25ea687e316356ce147a87d8725fb48a.gif" alt="パソコン教室パレハのライン登録" width="529" height="454"/></a></p></div></div><div class="adbox"><div style="padding-top:10px;"/></div></div><div class="sns st-sns-singular"><ul class="clearfix"><li class="twitter"> <a rel="nofollow" onclick="window.open('//twitter.com/intent/tweet?url=https%3A%2F%2Fpcacademy.jp%2Fexcel-vlookup-total&amp;hashtags=パソコン教室パレハ&amp;text=VLOOKUP%E3%81%A7%E5%90%88%E8%A8%88%E3%81%AF%E4%B8%8D%E5%8F%AF%E2%86%92SUMIF%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E3%81%86&amp;via=CurioMidorii&amp;tw_p=tweetbutton', '', 'width=500,height=450'); return false;"><i class="st-fa st-svg-twitter"/><span class="snstext ">Twitter</span></a></li><li class="facebook"> <a href="//www.facebook.com/sharer.php?src=bm&amp;u=https%3A%2F%2Fpcacademy.jp%2Fexcel-vlookup-total&amp;t=VLOOKUP%E3%81%A7%E5%90%88%E8%A8%88%E3%81%AF%E4%B8%8D%E5%8F%AF%E2%86%92SUMIF%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E3%81%86" target="_blank" rel="nofollow noopener"><i class="st-fa st-svg-facebook"/><span class="snstext ">Share</span> </a></li><li class="sns-pinterest"> <a data-pin-do="buttonPin" data-pin-custom="true" data-pin-tall="true" data-pin-round="true" href="https://www.pinterest.com/pin/create/button/?url=https%3A%2F%2Fpcacademy.jp%2Fexcel-vlookup-total&amp;media=https://pcacademy.jp/wp-content/uploads/2023/02/1-20.jpg&amp;description=今回の記事はExcel(エクセル)｜VLOOKUPで合計を出す方法についてお話します。 + 習得しておきたいVLOOKUP関数のテクニックはこちらをクリックして下さい Excel(エクセル)｜VLOO" rel="nofollow"><i class="st-fa st-svg-pinterest-p" aria-hidden="true"/><span class="snstext">Pinterest</span></a></li><li class="line"> <a href="//line.me/R/msg/text/?VLOOKUP%E3%81%A7%E5%90%88%E8%A8%88%E3%81%AF%E4%B8%8D%E5%8F%AF%E2%86%92SUMIF%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E3%81%86%0Ahttps%3A%2F%2Fpcacademy.jp%2Fexcel-vlookup-total" target="_blank" rel="nofollow noopener"><i class="st-fa st-svg-line" aria-hidden="true"/><span class="snstext">LINE</span></a></li></ul></div><aside><p class="author" style=";"><a href="https://pcacademy.jp/author/pcacademy" title="pcacademy" class="vcard author"><span class="fn">author</span></a></p><div class="p-navi clearfix"> <a class="st-prev-link" href="https://pcacademy.jp/pc-school-nagaokashi"><p class="st-prev"> <i class="st-svg st-svg-angle-right"/> </p><noscript><img width="60" height="60" src="https://pcacademy.jp/wp-content/uploads/2022/09/502547-100x100.png" class="attachment-60x60 size-60x60 wp-post-image" alt="新潟県の形をしたイラスト" decoding="async" srcset="https://pcacademy.jp/wp-content/uploads/2022/09/502547-100x100.png 100w, https://pcacademy.jp/wp-content/uploads/2022/09/502547-150x150.png 150w" sizes="(max-width: 60px) 100vw, 60px"/></noscript><img width="60" height="60" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%2060%2060%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2022/09/502547-100x100.png" class="lazyload attachment-60x60 size-60x60 wp-post-image" alt="新潟県の形をしたイラスト" decoding="async" data-srcset="https://pcacademy.jp/wp-content/uploads/2022/09/502547-100x100.png 100w, https://pcacademy.jp/wp-content/uploads/2022/09/502547-150x150.png 150w" data-sizes="(max-width: 60px) 100vw, 60px"/> <span class="st-prev-title">長岡市のパソコン教室・スクール｜大人向け｜おすすめ（人気・体験・料金）</span> </a> <a class="st-next-link" href="https://pcacademy.jp/excel-vlookup-spreadsheet"><p class="st-next"> <span class="st-prev-title">GoogleスプレッドシートでVLOOKUPを使う方法をわかりやすく解説</span> </p><noscript><img width="60" height="60" src="https://pcacademy.jp/wp-content/uploads/2023/02/1-21-100x100.jpg" class="attachment-60x60 size-60x60 wp-post-image" alt="Excel(エクセル)｜GoogleスプレッドシートでVLOOKUPを使う方法" decoding="async" srcset="https://pcacademy.jp/wp-content/uploads/2023/02/1-21-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/1-21-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/1-21-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/1-21.jpg 737w" sizes="(max-width: 60px) 100vw, 60px"/></noscript><img width="60" height="60" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%2060%2060%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2023/02/1-21-100x100.jpg" class="lazyload attachment-60x60 size-60x60 wp-post-image" alt="Excel(エクセル)｜GoogleスプレッドシートでVLOOKUPを使う方法" decoding="async" data-srcset="https://pcacademy.jp/wp-content/uploads/2023/02/1-21-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2023/02/1-21-640x640.jpg 640w, https://pcacademy.jp/wp-content/uploads/2023/02/1-21-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2023/02/1-21.jpg 737w" data-sizes="(max-width: 60px) 100vw, 60px"/> <i class="st-svg st-svg-angle-right"/> </a></div></aside></div></article></main></div><div id="side"><aside><div class="side-topad"><div id="text-4" class="ad widget_text"><div class="textwidget"><div class="center"><p><a href="https://pcacademy.jp/post-5919"><br/> <noscript><img decoding="async" class="wp-image-24109 size-full alignnone" src="https://pcacademy.jp/wp-content/uploads/2020/05/banner08.jpg" alt="パソコン教室のメリットは？" width="250" height="250" srcset="https://pcacademy.jp/wp-content/uploads/2020/05/banner08.jpg 250w, https://pcacademy.jp/wp-content/uploads/2020/05/banner08-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2020/05/banner08-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2020/05/banner08-60x60.jpg 60w" sizes="(max-width: 250px) 100vw, 250px"/></noscript><img decoding="async" class="lazyload wp-image-24109 size-full alignnone" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20250%20250%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2020/05/banner08.jpg" alt="パソコン教室のメリットは？" width="250" height="250" data-srcset="https://pcacademy.jp/wp-content/uploads/2020/05/banner08.jpg 250w, https://pcacademy.jp/wp-content/uploads/2020/05/banner08-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2020/05/banner08-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2020/05/banner08-60x60.jpg 60w" data-sizes="(max-width: 250px) 100vw, 250px"/><br/> </a></p><p><a href="https://pcacademy.jp/jimumikeiken"><br/> <noscript><img decoding="async" class="wp-image-24108 size-full" src="https://pcacademy.jp/wp-content/uploads/2020/05/banner09.jpg" alt="パソコンが苦手な方専門のパソコン教室" width="250" height="250" srcset="https://pcacademy.jp/wp-content/uploads/2020/05/banner09.jpg 250w, https://pcacademy.jp/wp-content/uploads/2020/05/banner09-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2020/05/banner09-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2020/05/banner09-60x60.jpg 60w" sizes="(max-width: 250px) 100vw, 250px"/></noscript><img decoding="async" class="lazyload wp-image-24108 size-full" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20250%20250%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2020/05/banner09.jpg" alt="パソコンが苦手な方専門のパソコン教室" width="250" height="250" data-srcset="https://pcacademy.jp/wp-content/uploads/2020/05/banner09.jpg 250w, https://pcacademy.jp/wp-content/uploads/2020/05/banner09-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2020/05/banner09-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2020/05/banner09-60x60.jpg 60w" data-sizes="(max-width: 250px) 100vw, 250px"/><br/> </a></p><p><a href="https://pcacademy.jp/typing-3"><br/> <noscript><img decoding="async" class="alignnone wp-image-22069 size-full" src="https://pcacademy.jp/wp-content/uploads/2020/04/banner10.jpg" alt="タイピングのコツ" width="250" height="250" srcset="https://pcacademy.jp/wp-content/uploads/2020/04/banner10.jpg 250w, https://pcacademy.jp/wp-content/uploads/2020/04/banner10-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2020/04/banner10-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2020/04/banner10-60x60.jpg 60w" sizes="(max-width: 250px) 100vw, 250px"/></noscript><img decoding="async" class="lazyload alignnone wp-image-22069 size-full" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20250%20250%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2020/04/banner10.jpg" alt="タイピングのコツ" width="250" height="250" data-srcset="https://pcacademy.jp/wp-content/uploads/2020/04/banner10.jpg 250w, https://pcacademy.jp/wp-content/uploads/2020/04/banner10-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2020/04/banner10-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2020/04/banner10-60x60.jpg 60w" data-sizes="(max-width: 250px) 100vw, 250px"/><br/> </a></p><p><a href="https://pcacademy.jp/typing"><br/> <noscript><img decoding="async" class="alignnone wp-image-22066 size-full" src="https://pcacademy.jp/wp-content/uploads/2020/04/banner06.jpg" alt="タイピング講座" width="250" height="250" srcset="https://pcacademy.jp/wp-content/uploads/2020/04/banner06.jpg 250w, https://pcacademy.jp/wp-content/uploads/2020/04/banner06-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2020/04/banner06-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2020/04/banner06-60x60.jpg 60w" sizes="(max-width: 250px) 100vw, 250px"/></noscript><img decoding="async" class="lazyload alignnone wp-image-22066 size-full" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20250%20250%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2020/04/banner06.jpg" alt="タイピング講座" width="250" height="250" data-srcset="https://pcacademy.jp/wp-content/uploads/2020/04/banner06.jpg 250w, https://pcacademy.jp/wp-content/uploads/2020/04/banner06-150x150.jpg 150w, https://pcacademy.jp/wp-content/uploads/2020/04/banner06-100x100.jpg 100w, https://pcacademy.jp/wp-content/uploads/2020/04/banner06-60x60.jpg 60w" data-sizes="(max-width: 250px) 100vw, 250px"/><br/> </a></p><p/><noscript><img decoding="async" class="alignnone wp-image-22069 size-full" src="https://pcacademy.jp/wp-content/uploads/2018/02/banner_marketing_ranking2.gif" alt="パソコン教室パレハランキング1位"/></noscript><img decoding="async" class="lazyload alignnone wp-image-22069 size-full" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/uploads/2018/02/banner_marketing_ranking2.gif" alt="パソコン教室パレハランキング1位"/></div></div></div><div id="search-3" class="ad widget_search"><div id="search" class="search-custom-d"><form method="get" id="searchform" action="https://pcacademy.jp/"> <label class="hidden" for="s"> </label> <input type="text" placeholder="検索したいテキストを入力" value="" name="s" id="s"/> <input type="submit" value="" class="st-fa" id="searchsubmit"/></form></div></div></div><div id="scrollad"/></aside></div></div></div><footer><div id="footer"><div id="footer-wrapper"><div id="footer-in"><div class="footermenubox clearfix "><ul id="menu-%e3%83%95%e3%83%83%e3%82%bf%e3%83%bc" class="footermenust"><li id="menu-item-21584" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-21584"><a href="https://pcacademy.jp/remote">パソコンオンライン教室</a></li><li id="menu-item-21795" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-21795"><a href="https://pcacademy.jp/company">会社概要｜株式会社デアルカ</a></li><li id="menu-item-25668" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-25668"><a href="https://pcacademy.jp/page-25666">特定商取引に基づく表示</a></li><li id="menu-item-26184" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-26184"><a href="https://pcacademy.jp/privacy-policy">プライバシーポリシー</a></li><li id="menu-item-21583" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-21583"><a href="https://pcacademy.jp/sitemap">サイトマップ</a></li></ul></div><div id="st-footer-logo-wrapper"><div id="st-text-logo"><h3 class="footerlogo st-text-logo-bottom"> <a href="https://pcacademy.jp/"> パソコン教室パレハ </a></h3></div><div class="st-footer-tel"><div id="text-3" class="headbox widget_text"><div class="textwidget"><div class="st-margin" style="margin: 14px 0 0 0;"><span class="st-mybtn st-mybtn-mini"><a style="background:#c4302b;border-radius:5px;font-weight:normal;color:#fff;box-shadow:0 3px 0 #f44336;" href="https://pcacademy.jp/contact-2"><i class="st-fa fa-envelope-o st-css-no" aria-hidden="true"/>お問い合わせ<i class="st-fa fa-after fa-angle-right st-css-no" aria-hidden="true"/></a></span><span class="st-mybtn st-mybtn-mini"><a style="background:#c4302b;border-radius:5px;font-weight:normal;color:#fff;box-shadow:0 3px 0 #f44336;" href="tel:0120-50-8350"><i class="st-fa fa-volume-control-phone st-css-no" aria-hidden="true"/>フリーダイヤル<i class="st-fa fa-after fa-angle-right st-css-no" aria-hidden="true"/></a></span><span class="st-mybtn st-mybtn-mini"><a style="background:#556b2f;border-radius:5px;font-weight:normal;color:#fff;box-shadow:0 3px 0 #8BC34A;" href="https://www.youtube.com/channel/UC6zyaoBtDdkHe5fF0Ufs5IQ" rel="nofollow"><i class="st-fa fa-pencil st-css-no" aria-hidden="true"/>Youtube動画<i class="st-fa fa-after fa-angle-right st-css-no" aria-hidden="true"/></a></span><span class="st-mybtn st-mybtn-mini"><a style="background:#556b2f;border-radius:5px;font-weight:normal;color:#fff;box-shadow:0 3px 0 #8BC34A;" href="https://pcacademy.jp/blog"><i class="st-fa fa-pencil st-css-no" aria-hidden="true"/>パソコン情報　<i class="st-fa fa-after fa-angle-right st-css-no" aria-hidden="true"/></a></span></div></div></div></div></div><p class="copyr"><small>© 2023 パソコン教室パレハ</small></p></div></div></div></footer></div></div></div> <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-MP6V3GG" height="0" width="0" style=";"/></noscript><div class="spfoot"><div id="" class="spfoot4 op m-tri"> <a href="#"> <span/> <span/> <span/></a></div><div class="spfoot1"> <a href="https://pcacademy.jp/contact-2" class="sv1"><noscript><img src="https://pcacademy.jp/wp-content/plugins/spkotei_bar/images/imal.gif" alt="メールの画像"/></noscript><img class="lazyload" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/plugins/spkotei_bar/images/imal.gif" alt="メールの画像"/></a><p>メールはこちら</p></div><div class="spfoot2"> <a href="https://line.me/R/ti/p/%40956hbkkc" class="sv2" rel="nofollow"><noscript><img src="https://pcacademy.jp/wp-content/plugins/spkotei_bar/images/ilin.gif" alt="ラインの画像"/></noscript><img class="lazyload" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/plugins/spkotei_bar/images/ilin.gif" alt="ラインの画像"/></a><p>LINEはこちら</p></div><div class="spfoot3"> <a href="tel:0120508350" class="sv3"><noscript><img src="https://pcacademy.jp/wp-content/plugins/spkotei_bar/images/imobi.gif" alt="電話の画像"/></noscript><img class="lazyload" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/wp-content/plugins/spkotei_bar/images/imobi.gif" alt="電話の画像"/></a><p>お電話はこちら</p></div></div> <noscript><img class="st-pvm-impression-tracker" src="https://pcacademy.jp/st-manager/pv-monitor/impression/track?query_type_id=single&amp;queried_id=61042&amp;queried_page=1&amp;url=https%3A%2F%2Fpcacademy.jp%2Fexcel-vlookup-total&amp;referrer=&amp;u=09c80ddb-6a07-4e23-a78b-84b99de83266" width="1" height="1" alt="" data-ogp-ignore=""/></noscript><img class="lazyload st-pvm-impression-tracker" src="data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%201%201%22%3E%3C/svg%3E" data-src="https://pcacademy.jp/st-manager/pv-monitor/impression/track?query_type_id=single&amp;queried_id=61042&amp;queried_page=1&amp;url=https%3A%2F%2Fpcacademy.jp%2Fexcel-vlookup-total&amp;referrer=&amp;u=09c80ddb-6a07-4e23-a78b-84b99de83266" width="1" height="1" alt="" data-ogp-ignore=""/> <noscript><style>.lazyload{;}</style></noscript> <div id="page-top"><a href="#wrapper" class="st-fa st-svg-angle-up"/></div></body>