PageSourceSearch

https://excel-microsoft.info/%E9%9B%86%E8%A8%88%E3%83%BB%E5%88%86%E6%9E%90/468

html excel-microsoft.info collected 2026-10-08 01:36:07 UTC 47,021 bytes, 529 lines download raw bytes

1<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja" xmlns:og="http://ogp.me/ns#" xmlns:fb="http://www.facebook.com/2008/fbml" itemscope="itemscope" itemtype="http://schema.org/WebPage">
2<head>
3<meta charset="utf-8">
4<meta name="viewport" content="width=device-width">
5<link rel="stylesheet" href="https://excel-microsoft.info/wp-content/themes/excel/style.css" type="text/css" media="all">
6<link href="//netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.css" rel="stylesheet">
7
8<!------------------------▼▼▼ Search Console -->
9<meta name="google-site-verification" content="-Gp2zvMuRHsg3zfUT8DxJqEb89YngfCU0clgYbOr2ss" />
10
11<!------------------------▼▼▼ ColorBox -->
12<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
vendor: 1 bytes, line 12
12
13<script type="text/javascript" src="https://excel-microsoft.info/wp-content/themes/excel/js/jquery.colorbox-min.js" ></script>
13
14<link rel="stylesheet" type="text/css" href="https://excel-microsoft.info/wp-content/themes/excel/css/colorbox.css" media="screen" />
15
16<script type="text/javascript">
17$(function() { 
18$('a[rel^=lightbox]').colorbox({maxWidth:'100%',maxHeight:'100%',speed:'200' ,opacity: 0.7});
19$("a[rel='slide1']").colorbox({slideshow:true,loop:false,slideshowSpeed:2000,maxWidth:"90%",maxHeight:"90%",opacity: 0.7});
20$("a[rel='slide2']").colorbox({slideshow:true,loop:false,slideshowSpeed:2000,maxWidth:"90%",maxHeight:"90%",opacity: 0.7});
21});
22</script>
22
23<!------------------------▲▲▲ ColorBox -->
24
25<!------------------------▼▼▼ Google ページ単位の広告 -->
26<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
vendor: 1 bytes, line 26
26
27<script>
28  (adsbygoogle = window.adsbygoogle || []).push({
29    google_ad_client: "ca-pub-0611203521553800",
30    enable_page_level_ads: true
31  });
32</script>
32
33<!------------------------▲▲▲ Google ページ単位の広告 -->
34
35
36
37
38
39		<!-- All in One SEO 4.1.8 -->
40		<title>同じ項目をまとめてグループごとに集計|Excel(エクセル)の使い方</title>
41		<meta name="description" content="Excelの表で同じ項目をグループとして集計する方法と集計(小計)を解除(クリア)する手順。グループにまとめたい項目で並び替え(ソート)し小計する方法を初心者にも分かりやすく解説。" />
42		<meta name="robots" content="max-snippet:-1, max-image-preview:large, max-video-preview:-1" />
43		<meta name="keywords" content="エクセル,excel,集計,小計,合計,データの個数,最大値,最小値,平均,解除,クリア" />
44		<link rel="canonical" href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/468" />
45		<meta property="og:locale" content="ja_JP" />
46		<meta property="og:site_name" content="Excel(エクセル)の使い方[初心者編]" />
47		<meta property="og:type" content="website" />
48		<meta property="og:title" content="同じ項目をまとめてグループごとに集計|Excel(エクセル)の使い方" />
49		<meta property="og:description" content="Excelの表で同じ項目をグループとして集計する方法と集計(小計)を解除(クリア)する手順。グループにまとめたい項目で並び替え(ソート)し小計する方法を初心者にも分かりやすく解説。" />
50		<meta property="og:url" content="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/468" />
51		<meta property="og:image" content="https://excel-microsoft.info/wp-content/uploads/009/009004_00.png" />
52		<meta property="og:image:secure_url" content="https://excel-microsoft.info/wp-content/uploads/009/009004_00.png" />
53		<meta name="twitter:card" content="summary_large_image" />
54		<meta name="twitter:title" content="同じ項目をまとめてグループごとに集計|Excel(エクセル)の使い方" />
55		<meta name="twitter:description" content="Excelの表で同じ項目をグループとして集計する方法と集計(小計)を解除(クリア)する手順。グループにまとめたい項目で並び替え(ソート)し小計する方法を初心者にも分かりやすく解説。" />
56		<meta name="twitter:image" content="https://excel-microsoft.info/wp-content/uploads/009/009004_00.png" />
57		<meta name="google" content="nositelinkssearchbox" />
58		
58<script type="application/ld+json" class="aioseo-schema">
59			{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/excel-microsoft.info\/#website","url":"https:\/\/excel-microsoft.info\/","name":"\u521d\u5fc3\u8005\u306b\u3082\u5206\u304b\u308bExcel\u306e\u4f7f\u3044\u65b9","description":"Excel\u306e\u4f7f\u3044\u65b9\u3092\u521d\u5fc3\u8005\u306b\u3082\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac","inLanguage":"ja","publisher":{"@id":"https:\/\/excel-microsoft.info\/#organization"}},{"@type":"Organization","@id":"https:\/\/excel-microsoft.info\/#organization","name":"\u521d\u5fc3\u8005\u306b\u3082\u5206\u304b\u308bExcel\u306e\u4f7f\u3044\u65b9","url":"https:\/\/excel-microsoft.info\/"},{"@type":"BreadcrumbList","@id":"https:\/\/excel-microsoft.info\/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90\/468#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/excel-microsoft.info\/#listItem","position":1,"item":{"@type":"WebPage","@id":"https:\/\/excel-microsoft.info\/","name":"\u30db\u30fc\u30e0","description":"Excel\u306e\u4f7f\u3044\u65b9\u3092\u521d\u5fc3\u8005\u306b\u3082\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac","url":"https:\/\/excel-microsoft.info\/"},"nextItem":"https:\/\/excel-microsoft.info\/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90\/#listItem"},{"@type":"ListItem","@id":"https:\/\/excel-microsoft.info\/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90\/#listItem","position":2,"item":{"@type":"WebPage","@id":"https:\/\/excel-microsoft.info\/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90\/","name":"\u96c6\u8a08\u30fb\u5206\u6790","description":"Excel\u306e\u8868\u3067\u540c\u3058\u9805\u76ee\u3092\u30b0\u30eb\u30fc\u30d7\u3068\u3057\u3066\u96c6\u8a08\u3059\u308b\u65b9\u6cd5\u3068\u96c6\u8a08(\u5c0f\u8a08)\u3092\u89e3\u9664(\u30af\u30ea\u30a2)\u3059\u308b\u624b\u9806\u3002\u30b0\u30eb\u30fc\u30d7\u306b\u307e\u3068\u3081\u305f\u3044\u9805\u76ee\u3067\u4e26\u3073\u66ff\u3048(\u30bd\u30fc\u30c8)\u3057\u5c0f\u8a08\u3059\u308b\u65b9\u6cd5\u3092\u521d\u5fc3\u8005\u306b\u3082\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3002","url":"https:\/\/excel-microsoft.info\/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90\/"},"previousItem":"https:\/\/excel-microsoft.info\/#listItem"}]},{"@type":"Person","@id":"https:\/\/excel-microsoft.info\/author\/katahira#author","url":"https:\/\/excel-microsoft.info\/author\/katahira","name":"Excel\u306e\u4f7f\u3044\u65b9\uff5c\u7ba1\u7406\u4eba"},{"@type":"WebPage","@id":"https:\/\/excel-microsoft.info\/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90\/468#webpage","url":"https:\/\/excel-microsoft.info\/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90\/468","name":"\u540c\u3058\u9805\u76ee\u3092\u307e\u3068\u3081\u3066\u30b0\u30eb\u30fc\u30d7\u3054\u3068\u306b\u96c6\u8a08\uff5cExcel(\u30a8\u30af\u30bb\u30eb)\u306e\u4f7f\u3044\u65b9","description":"Excel\u306e\u8868\u3067\u540c\u3058\u9805\u76ee\u3092\u30b0\u30eb\u30fc\u30d7\u3068\u3057\u3066\u96c6\u8a08\u3059\u308b\u65b9\u6cd5\u3068\u96c6\u8a08(\u5c0f\u8a08)\u3092\u89e3\u9664(\u30af\u30ea\u30a2)\u3059\u308b\u624b\u9806\u3002\u30b0\u30eb\u30fc\u30d7\u306b\u307e\u3068\u3081\u305f\u3044\u9805\u76ee\u3067\u4e26\u3073\u66ff\u3048(\u30bd\u30fc\u30c8)\u3057\u5c0f\u8a08\u3059\u308b\u65b9\u6cd5\u3092\u521d\u5fc3\u8005\u306b\u3082\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3002","inLanguage":"ja","isPartOf":{"@id":"https:\/\/excel-microsoft.info\/#website"},"breadcrumb":{"@id":"https:\/\/excel-microsoft.info\/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90\/468#breadcrumblist"},"author":"https:\/\/excel-microsoft.info\/author\/katahira#author","creator":"https:\/\/excel-microsoft.info\/author\/katahira#author","datePublished":"2018-05-31T14:10:07+09:00","dateModified":"2018-06-09T01:05:30+09:00"},{"@type":"Article","@id":"https:\/\/excel-microsoft.info\/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90\/468#article","name":"\u540c\u3058\u9805\u76ee\u3092\u307e\u3068\u3081\u3066\u30b0\u30eb\u30fc\u30d7\u3054\u3068\u306b\u96c6\u8a08\uff5cExcel(\u30a8\u30af\u30bb\u30eb)\u306e\u4f7f\u3044\u65b9","description":"Excel\u306e\u8868\u3067\u540c\u3058\u9805\u76ee\u3092\u30b0\u30eb\u30fc\u30d7\u3068\u3057\u3066\u96c6\u8a08\u3059\u308b\u65b9\u6cd5\u3068\u96c6\u8a08(\u5c0f\u8a08)\u3092\u89e3\u9664(\u30af\u30ea\u30a2)\u3059\u308b\u624b\u9806\u3002\u30b0\u30eb\u30fc\u30d7\u306b\u307e\u3068\u3081\u305f\u3044\u9805\u76ee\u3067\u4e26\u3073\u66ff\u3048(\u30bd\u30fc\u30c8)\u3057\u5c0f\u8a08\u3059\u308b\u65b9\u6cd5\u3092\u521d\u5fc3\u8005\u306b\u3082\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3002","inLanguage":"ja","headline":"\u540c\u3058\u9805\u76ee\u3092\u307e\u3068\u3081\u3066\u30b0\u30eb\u30fc\u30d7\u3054\u3068\u306b\u96c6\u8a08","author":{"@id":"https:\/\/excel-microsoft.info\/author\/katahira#author"},"publisher":{"@id":"https:\/\/excel-microsoft.info\/#organization"},"datePublished":"2018-05-31T14:10:07+09:00","dateModified":"2018-06-09T01:05:30+09:00","articleSection":"\u96c6\u8a08\u30fb\u5206\u6790, \u5408\u8a08, \u5e73\u5747, \u6700\u5927\u5024, \u6700\u5c0f\u5024, \u8c46\u77e5\u8b58, \u96c6\u8a08","mainEntityOfPage":{"@id":"https:\/\/excel-microsoft.info\/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90\/468#webpage"},"isPartOf":{"@id":"https:\/\/excel-microsoft.info\/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90\/468#webpage"},"image":{"@type":"ImageObject","@id":"https:\/\/excel-microsoft.info\/#articleImage","url":"https:\/\/excel-microsoft.info\/wp-content\/uploads\/009\/009004_00.png"}}]}
60		</script>
60
61		<!-- All in One SEO -->
62
63<link rel='dns-prefetch' href='//platform-api.sharethis.com' />
64<link rel='dns-prefetch' href='//s.w.org' />
65<link rel="alternate" type="application/rss+xml" title="初心者にも分かるExcelの使い方 &raquo; 同じ項目をまとめてグループごとに集計 のコメントのフィード" href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/468/feed" />
66<script type="text/javascript">
67window._wpemojiSettings = {"baseUrl":"https:\/\/s.w.org\/images\/core\/emoji\/13.1.0\/72x72\/","ext":".png","svgUrl":"https:\/\/s.w.org\/images\/core\/emoji\/13.1.0\/svg\/","svgExt":".svg","source":{"concatemoji":"https:\/\/excel-microsoft.info\/wp-includes\/js\/wp-emoji-release.min.js"}};
68/*! This file is auto-generated */
69!function(e,a,t){var n,r,o,i=a.createElement("canvas"),p=i.getContext&&i.getContext("2d");function s(e,t){var a=String.fromCharCode;p.clearRect(0,0,i.width,i.height),p.fillText(a.apply(this,e),0,0);e=i.toDataURL();return p.clearRect(0,0,i.width,i.height),p.fillText(a.apply(this,t),0,0),e===i.toDataURL()}function c(e){var t=a.createElement("script");t.src=e,t.defer=t.type="text/javascript",a.getElementsByTagName("head")[0].appendChild(t)}for(o=Array("flag","emoji"),t.supports={everything:!0,everythingExceptFlag:!0},r=0;r<o.length;r++)t.supports[o[r]]=function(e){if(!p||!p.fillText)return!1;switch(p.textBaseline="top",p.font="600 32px Arial",e){case"flag":return s([127987,65039,8205,9895,65039],[127987,65039,8203,9895,65039])?!1:!s([55356,56826,55356,56819],[55356,56826,8203,55356,56819])&&!s([55356,57332,56128,56423,56128,56418,56128,56421,56128,56430,56128,56423,56128,56447],[55356,57332,8203,56128,56423,8203,56128,56418,8203,56128,56421,8203,56128,56430,8203,56128,56423,8203,56128,56447]);case"emoji":return!s([10084,65039,8205,55357,56613],[10084,65039,8203,55357,56613])}return!1}(o[r]),t.supports.everything=t.supports.everything&&t.supports[o[r]],"flag"!==o[r]&&(t.supports.everythingExceptFlag=t.supports.everythingExceptFlag&&t.supports[o[r]]);t.supports.everythingExceptFlag=t.supports.everythingExceptFlag&&!t.supports.flag,t.DOMReady=!1,t.readyCallback=function(){t.DOMReady=!0},t.supports.everything||(n=function(){t.readyCallback()},a.addEventListener?(a.addEventListener("DOMContentLoaded",n,!1),e.addEventListener("load",n,!1)):(e.attachEvent("onload",n),a.attachEvent("onreadystatechange",function(){"complete"===a.readyState&&t.readyCallback()})),(n=t.source||{}).concatemoji?c(n.concatemoji):n.wpemoji&&n.twemoji&&(c(n.twemoji),c(n.wpemoji)))}(window,document,window._wpemojiSettings);
70</script>
70
71<style type="text/css">
72img.wp-smiley,
73img.emoji {
74	display: inline !important;
75	border: none !important;
76	box-shadow: none !important;
77	height: 1em !important;
78	width: 1em !important;
79	margin: 0 0.07em !important;
80	vertical-align: -0.1em !important;
81	background: none !important;
82	padding: 0 !important;
83}
84</style>
85	<link rel='stylesheet' id='wp-block-library-css'  href='https://excel-microsoft.info/wp-includes/css/dist/block-library/style.min.css' type='text/css' media='all' />
86<style id='global-styles-inline-css' type='text/css'>
87body{--wp--preset--color--black: #000000;--wp--preset--color--cyan-bluish-gray: #abb8c3;--wp--preset--color--white: #ffffff;--wp--preset--color--pale-pink: #f78da7;--wp--preset--color--vivid-red: #cf2e2e;--wp--preset--color--luminous-vivid-orange: #ff6900;--wp--preset--color--luminous-vivid-amber: #fcb900;--wp--preset--color--light-green-cyan: #7bdcb5;--wp--preset--color--vivid-green-cyan: #00d084;--wp--preset--color--pale-cyan-blue: #8ed1fc;--wp--preset--color--vivid-cyan-blue: #0693e3;--wp--preset--color--vivid-purple: #9b51e0;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple: linear-gradient(135deg,rgba(6,147,227,1) 0%,rgb(155,81,224) 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan: linear-gradient(135deg,rgb(122,220,180) 0%,rgb(0,208,130) 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange: linear-gradient(135deg,rgba(252,185,0,1) 0%,rgba(255,105,0,1) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red: linear-gradient(135deg,rgba(255,105,0,1) 0%,rgb(207,46,46) 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray: linear-gradient(135deg,rgb(238,238,238) 0%,rgb(169,184,195) 100%);
87--wp--preset--gradient--cool-to-warm-spectrum: linear-gradient(135deg,rgb(74,234,220) 0%,rgb(151,120,209) 20%,rgb(207,42,186) 40%,rgb(238,44,130) 60%,rgb(251,105,98) 80%,rgb(254,248,76) 100%);--wp--preset--gradient--blush-light-purple: linear-gradient(135deg,rgb(255,206,236) 0%,rgb(152,150,240) 100%);--wp--preset--gradient--blush-bordeaux: linear-gradient(135deg,rgb(254,205,165) 0%,rgb(254,45,45) 50%,rgb(107,0,62) 100%);--wp--preset--gradient--luminous-dusk: linear-gradient(135deg,rgb(255,203,112) 0%,rgb(199,81,192) 50%,rgb(65,88,208) 100%);--wp--preset--gradient--pale-ocean: linear-gradient(135deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%);--wp--preset--gradient--electric-grass: linear-gradient(135deg,rgb(202,248,128) 0%,rgb(113,206,126) 100%);--wp--preset--gradient--midnight: linear-gradient(135deg,rgb(2,3,129) 0%,rgb(40,116,252) 100%);--wp--preset--duotone--dark-grayscale: url('#wp-duotone-dark-grayscale');--wp--preset--duotone--grayscale: url('#wp-duotone-grayscale');--wp--preset--duotone--purple-yellow: url('#wp-duotone-purple-yellow');--wp--preset--duotone--blue-red: url('#wp-duotone-blue-red');--wp--preset--duotone--midnight: url('#wp-duotone-midnight');--wp--preset--duotone--magenta-yellow: url('#wp-duotone-magenta-yellow');--wp--preset--duotone--purple-green: url('#wp-duotone-purple-green');--wp--preset--duotone--blue-orange: url('#wp-duotone-blue-orange');--wp--preset--font-size--small: 13px;--wp--preset--font-size--medium: 20px;--wp--preset--font-size--large: 36px;--wp--preset--font-size--x-large: 42px;}.has-black-color{color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color: var(--wp--preset--color--white) !important;}.has-pale-pink-color{color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color: var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color: var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color: var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color: var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color: var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background: var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background: var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}
87.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background: var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background: var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background: var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background: var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background: var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background: var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background: var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background: var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size: var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size: var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size: var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size: var(--wp--preset--font-size--x-large) !important;}
88</style>
89<script type='text/javascript' src='//platform-api.sharethis.com/js/sharethis.js#product=ga&#038;property=621d9ebbb846610019d3dc93' id='googleanalytics-platform-sharethis-js'></script>
89
90<link rel="https://api.w.org/" href="https://excel-microsoft.info/wp-json/" /><link rel="alternate" type="application/json" href="https://excel-microsoft.info/wp-json/wp/v2/posts/468" /><link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://excel-microsoft.info/xmlrpc.php?rsd" />
91<link rel="wlwmanifest" type="application/wlwmanifest+xml" href="https://excel-microsoft.info/wp-includes/wlwmanifest.xml" /> 
92<meta name="generator" content="WordPress 5.9.19" />
93<link rel='shortlink' href='https://excel-microsoft.info/?p=468' />
94<link rel="alternate" type="application/json+oembed" href="https://excel-microsoft.info/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fexcel-microsoft.info%2F%25e9%259b%2586%25e8%25a8%2588%25e3%2583%25bb%25e5%2588%2586%25e6%259e%2590%2F468" />
95<link rel="alternate" type="text/xml+oembed" href="https://excel-microsoft.info/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fexcel-microsoft.info%2F%25e9%259b%2586%25e8%25a8%2588%25e3%2583%25bb%25e5%2588%2586%25e6%259e%2590%2F468&#038;format=xml" />
96<script>
97(function() {
98	(function (i, s, o, g, r, a, m) {
99		i['GoogleAnalyticsObject'] = r;
100		i[r] = i[r] || function () {
101				(i[r].q = i[r].q || []).push(arguments)
102			}, i[r].l = 1 * new Date();
103		a = s.createElement(o),
104			m = s.getElementsByTagName(o)[0];
105		a.async = 1;
106		a.src = g;
107		m.parentNode.insertBefore(a, m)
108	})(window, document, 'script', 'https://google-analytics.com/analytics.js', 'ga');
109
110	ga('create', 'UA-73790842-6', 'auto');
111			ga('send', 'pageview');
112	})();
113</script>
113
114<style type="text/css">.broken_link, a.broken_link {
115	text-decoration: line-through;
116}</style>
117<!-- shortcut icon -->
118<link rel="apple-touch-icon" href="https://excel-microsoft.info/wp-content/themes/excel/img/apple-touch-icon.png" />
119<link rel="shortcut icon" href="https://excel-microsoft.info/wp-content/themes/excel/img/favicon.ico" />
120
121<meta itemprop="name" content="同じ項目をまとめてグループごとに集計" />
122
123<script type="text/javascript" src="https://excel-microsoft.info/wp-content/themes/excel/js/script.js"></script>
vendor: 1 bytes, line 123
123
124<script type="text/javascript" src="https://excel-microsoft.info/wp-content/themes/excel/js/jquery.smoothscroll.js"></script>
vendor: 1 bytes, line 124
124
125<script type="text/javascript" src="https://excel-microsoft.info/wp-content/themes/excel/js/jquery.rollover.js"></script>
vendor: 1 bytes, line 125
125
126<script type="text/javascript" src="https://excel-microsoft.info/wp-content/themes/excel/js/jquery.slideshow.js"></script>
vendor: 1 bytes, line 126
126
127<script>
128$(function(){
129    $('html').smoothscroll({easing : 'swing', speed : 1000, margintop : 10});
130    $('.totop').scrollshow({position : 500});
131    $('.slide').slideshow({
132        touch        : true,
133        touchDistance : '80',
134        bgImage      : false,
135        autoSlide    : true,
136        effect       : 'slide',
137        repeat       : true,
138        easing       : 'swing',
139        interval     : 3000,
140        duration     : 1000,
141        imgHoverStop : true,
142        navHoverStop : true,
143        navImg       : false,
144        navImgCustom : false,
145        navImgSuffix : ''
146    });
147    $('.slidePrev img').rollover();
148    $('.slideNext img').rollover();
149    });
150</script>
150
151<!--[if lt IE 9]>
152   
152<script src="https://excel-microsoft.info/wp-content/themes/excel/js/html5shiv.js"></script>
152
153   
153<script src="https://excel-microsoft.info/wp-content/themes/excel/js/css3-mediaqueries.js"></script>
153
154<![endif]-->
155</head>
156
157<body>
158
159<!-- google analytics 始まり -->
160<script>
vendor: 344 bytes, lines 160-165
160
161  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
162  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
163  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
164  })(window,document,'script','https://www.google-analytics.com/analytics.js','ga');
165  ga('create', '
165UA-73790842-6
vendor: 38 bytes, lines 165-166
165', 'auto');
166  ga('send', 'pageview');
167</script>
167
168<!-- google analytics 終わり -->
169
170
171<script>(function(d, s, id) {
172  var js, fjs = d.getElementsByTagName(s)[0];
173  if (d.getElementById(id)) return;
174  js = d.createElement(s); js.id = id;
175  js.src = "//connect.facebook.net/ja_JP/sdk.js#xfbml=1&version=v2.3";
176  fjs.parentNode.insertBefore(js, fjs);
177}(document, 'script', 'facebook-jssdk'));</script>
177
178
179<header><div id="head">		<!-- #head 始まり -->
180<h1>Excelの使い方|同じ項目をまとめてグループごとに集計</h1>
181<a href="https://excel-microsoft.info"><img src="https://excel-microsoft.info/wp-content/themes/excel/img/title.png" alt="エクセル(Excel)の使い方" /></a>
182<p class="head_descri">初心者にも分かりやすくExcelの使い方を解説。エクセルの基本操作や表やグラフを見やすくする方法。よく使う関数などを説明</p>
183</div></header>			<!-- #head 終わり -->
184
185
186<!-- TOP広告を大きく -->
187<aside>
188<!-- ▼AdSence -->
189<div class="adsense_top_unit">
190<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
190
191<!-- 728x15 Excel リンクUNIT -->
192<ins class="adsbygoogle"
193     style="display:inline-block;width:728px;height:15px"
194     data-ad-client="ca-pub-0611203521553800"
195     data-ad-slot="7391175496"></ins>
196<script>
197(adsbygoogle = window.adsbygoogle || []).push({});
198</script>
198</div>
199<!-- ▲AdSence -->
200</aside>
201
202<div id="contents">	<!-- #contents 始まり -->
203<div id="wrap">	<!-- #wrap 始まり -->
204
205<!-- TOP広告を小さく -->
206
207<!-- ▼パン屑ナビ -->
208<nav><div class="topicpath">
209<ol><li itemscope="itemscope" itemtype="http://data-vocabulary.org/Breadcrumb"><a href="https://excel-microsoft.info" itemprop="url"><span itemprop="title">初心者にも分かるExcelの使い方</span></a></li><li itemscope="itemscope" itemtype="http://data-vocabulary.org/Breadcrumb"><a href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90" itemprop="url"> <span itemprop="title">集計・分析</span></a> </li></ol></div></nav>	<!-- ▲パン屑 ナビ-->
210
211<main><div id="box_main">	<!-- #box_main 始まり -->
212
213<article><div class="entry_area">	<!-- .entry_area 始まり -->
214
215
216
217<h2><a href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/468" rel="bookmark" title="Permanent Link to 同じ項目をまとめてグループごとに集計">同じ項目をまとめてグループごとに集計</a></h2>
218
219
220<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
220
221<!-- Excel[ディスプレイ上] -->
222<ins class="adsbygoogle"
223     style="display:block"
224     data-ad-client="ca-pub-0611203521553800"
225     data-ad-slot="4520750780"
226     data-ad-format="auto"></ins>
227<script>
228(adsbygoogle = window.adsbygoogle || []).push({});
229</script>
229
230
231<p class="mgn20-20">
232<img src="https://excel-microsoft.info/wp-content/uploads/009/009004_00.png" width="600" height="315" alt="同じ項目をまとめてグループごとに集計|Excel(エクセル)の使い方" /><br />
233Excelの表で同じ項目をグループとして集計する方法と集計を解除(クリア)する手順。グループにまとめたい項目で並び替え(ソート)し小計する方法を初心者にも分かりやすく解説
234</p>
235
236<div align="center">
237<hr style="border:none;border-top:dashed 2px #a9a9a9;width:70%;">
238<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
238
239<ins class="adsbygoogle"
240     style="display:block; text-align:center;"
241     data-ad-format="fluid"
242     data-ad-layout="in-article"
243     data-ad-client="ca-pub-0611203521553800"
244     data-ad-slot="5139875491"></ins>
245<script>
246     (adsbygoogle = window.adsbygoogle || []).push({});
247</script>
247
248<hr style="border:none;border-top:dashed 2px #a9a9a9;width:70%;">
249</div>
250<h3>Excelの表で同じ項目をグループごとに集計する</h3>
251<p class="mgn00-20">
252グループごとに集計するにはグループにする項目が表の中で連続している必要があります。<br />
253ですので<strong>集計</strong>を行う際はまず「<strong>並び替え</strong>」を行います。<br />
254<img src="https://excel-microsoft.info/wp-content/uploads/009/009004_001.png" alt="Excelの表で同じ項目をグループごとに集計する" />
255</p>
256<h4 class="h01">集計のグループの基準となにする項目を選択</h4>
257<p class="mgn00-20">
258<a href="https://excel-microsoft.info/wp-content/uploads/009/009004_002.png" rel="lightbox" ><br />
259<img src="https://excel-microsoft.info/wp-content/uploads/009/009004_002.png" alt="並び替えを行ってからグループごとの集計(小計)を行う" /></a><br />
260<span class="num">2</span>[ホーム]タブ<br />
261<span class="num">3</span>[編集]ボタン<br />
262<span class="num">4</span>[<em>並び替えとフィルター</em>]から[昇順](もしくは[降順])を選択
263</p>
264<p class="mgn20-20">
265グループとしてまとめたい[商品]が並び変わったのを確認。
266</p>
267<h4>[小計]ボタンが押せない場合</h4>
268<p class="mgn00-20">
269表がテーブルに変換されている可能性があります。<br />
270<a href="https://excel-microsoft.info/%E9%9B%86%E8%A8%88%E3%83%BB%E5%88%86%E6%9E%90/463">Excelのテーブルを解除</a> してから設定してみて下さい。
271</p>
272<h4>データをグループごと集計する</h4>
273<p class="mgn00-20">
274<a href="https://excel-microsoft.info/wp-content/uploads/009/009004_003.png" rel="lightbox" ><br />
275<img src="https://excel-microsoft.info/wp-content/uploads/009/009004_003.png" alt="データ→アウトライン→小計で[集計の設定]ダイアログ" /></a><br />
276<span class="num">5</span>[データ]<br />
277<span class="num">6</span>[アウトライン]<br />
278<span class="num">7</span>[<strong>小計</strong>]ボタン
279</p>
280<p class="mgn20-20">
281<img src="https://excel-microsoft.info/wp-content/uploads/009/009004_004.png" alt="[集計の設定]ダイアログでグループの基準と集計方法を設定" /><br />
282[<strong>グループの基準</strong>]は(今回の例では)先ほど並び替えの基準にした[商品]<br />
283[<strong>集計の方法</strong>]は(今回は)[金額]の「合計」<br />
284作成された元のデータによりますが、例えば<br />
285※何回注文をもらっているかの場合は[データの個数]とか・・<br />
286※一回の[注文]の[平均]金額など、必要な集計方法を適宜選択して下さい。
287</p>
288<p class="mgn20-20">
289[OK]ボタンを押下すると、明細部分にグループごとの小計行が付与されたデータが作成されます。<br />
290<img src="https://excel-microsoft.info/wp-content/uploads/009/009004_005.png" alt="各グループの明細の下に集計行が追加されます" class="iimage" /><br />
291<span class="num">2</span>をクリックすると明細部分が畳まれ、グループの集計行(例では合計)のみが一覧表示になります。<br />
292<img src="https://excel-microsoft.info/wp-content/uploads/009/009004_006.png" alt="集計画面で明細を畳み、グループごとの一覧表示も可能" class="iimage" /></p>
293<p><span class="num">1</span>をクリックするとグループの集計行も畳まれ、総計のみが表示されます。<br />
294<img src="https://excel-microsoft.info/wp-content/uploads/009/009004_007.png" alt="集計画面では総計のみを表示する事も可能" class="iimage" /></p>
295<p><span class="num">2</span><span class="num">3</span>をクリックすると畳まれた明細を開いて確認が可能。
296</p>
297
298<div align="center">
299<hr style="border:none;border-top:dashed 2px #a9a9a9;width:70%;">
300<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
300
301<ins class="adsbygoogle"
302     style="display:block; text-align:center;"
303     data-ad-format="fluid"
304     data-ad-layout="in-article"
305     data-ad-client="ca-pub-0611203521553800"
306     data-ad-slot="5139875491"></ins>
307<script>
308     (adsbygoogle = window.adsbygoogle || []).push({});
309</script>
309
310<hr style="border:none;border-top:dashed 2px #a9a9a9;width:70%;">
311</div>
312<h3>Excelの集計を解除(クリア)する方法</h3>
313<h4 class="h01">解除したい集計の表を選択</h4>
314<p class="mgn00-20">
315<a href="https://excel-microsoft.info/wp-content/uploads/009/009004_008.png" rel="lightbox" ><br />
316<img src="https://excel-microsoft.info/wp-content/uploads/009/009004_008.png" alt="エクセルの集計(小計)を解除(クリア)する方法" /></a><br />
317<span class="num">2</span>[データ]<br />
318<span class="num">3</span>[アウトライン]<br />
319<span class="num">4</span>[小計]ボタン
320</p>
321<p class="mgn20-20">
322<img src="https://excel-microsoft.info/wp-content/uploads/009/009004_009.png" alt="[集計の設定]ダイアログで[すべてを削除]で解除" class="iimage" /><br />
323[すべて削除]で集計表が解除され、通常の表に戻ります。</p>
324<div class='yarpp yarpp-related yarpp-related-website yarpp-template-list'>
325<!-- YARPP List -->
326<hr /><div><aside>この記事と関連性が高い記事
327<p><a href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/459" rel="bookmark" title="表をテーブルに変換すると集計や解析が簡単に行える">表をテーブルに変換すると集計や解析が簡単に行える </a></p>
328<p><a href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/463" rel="bookmark" title="Excelで作成したテーブルを元の表に戻す方法">Excelで作成したテーブルを元の表に戻す方法 </a></p>
329<p><a href="https://excel-microsoft.info/%e9%96%a2%e6%95%b0/254" rel="bookmark" title="指定範囲の最大値を求めるMAX関数">指定範囲の最大値を求めるMAX関数 </a></p>
330<p><a href="https://excel-microsoft.info/%e9%96%a2%e6%95%b0/257" rel="bookmark" title="指定範囲の最小値を求めるMIN関数">指定範囲の最小値を求めるMIN関数 </a></p>
331<p><a href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/466" rel="bookmark" title="データの並び替え。複数の条件でソート">データの並び替え。複数の条件でソート </a></p>
332</div></aside>
333</div>
334</div></article>	<!-- .entry_area 終わり -->
335
336
337<aside>
338<!-- ▼AdSence -->
339<div class="ads_lower">
340<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
340
341<!-- 300x250 Excel 記事下x2 -->
342<ins class="adsbygoogle"
343     style="display:inline-block;width:300px;height:250px"
344     data-ad-client="ca-pub-0611203521553800"
345     data-ad-slot="8867908697"></ins>
346<script>
347(adsbygoogle = window.adsbygoogle || []).push({});
348</script>
348<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
348
349<!-- 300x250 Excel 記事下x2 -->
350<ins class="adsbygoogle"
351     style="display:inline-block;width:300px;height:250px"
352     data-ad-client="ca-pub-0611203521553800"
353     data-ad-slot="8867908697"></ins>
354<script>
355(adsbygoogle = window.adsbygoogle || []).push({});
356</script>
356</div>
357
358<div class="ads_lower_sm">
359<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
359
360<!-- Excelレスポンジブ -->
361<ins class="adsbygoogle"
362     style="display:block"
363     data-ad-client="ca-pub-0611203521553800"
364     data-ad-slot="6687749126"
365     data-ad-format="auto"></ins>
366<script>
367(adsbygoogle = window.adsbygoogle || []).push({});
368</script>
368</div>
369<!-- ▲AdSence -->
370</aside>
371
372
373<article>
374<div class="comment_area">
375<h4>同じ項目をまとめてグループごとに集計へのコメント</h4>
376
377
378
379	<div id="respond" class="comment-respond">
380		<h3 id="reply-title" class="comment-reply-title">この記事へのコメントを書く <small><a rel="nofollow" id="cancel-comment-reply-link" href="/%E9%9B%86%E8%A8%88%E3%83%BB%E5%88%86%E6%9E%90/468#respond" style="display:none;">コメントをキャンセル</a></small></h3><form action="https://excel-microsoft.info/wp-comments-post.php" method="post" id="commentform" class="comment-form"><p class="commentNotesBefore">入力エリアすべてが必須項目です。<br />メールアドレスが公開されません。<br />※URLはリンクされません</p><div><lable>コメント</lable><br><textarea id="comment" name="comment" cols="35" rows="7" aria-required="true" placeholder="コメント" /></textarea></div><p class="commentNotesAfter">内容をご確認の上、送信してください。</p><div><lable>名前(ニックネーム)</lable><br><input id="author" class="text" name="author" type="text" value="" size="35" placeholder="お名前" /></div>
381<div><lable>メールアドレス</lable><br /><input id="email" name="email" class="text" type="text" value="" size="35"placeholder="メールアドレス" /></p></div>
382
383<p><img src="https://excel-microsoft.info/wp-content/plugins/siteguard/really-simple-captcha/tmp/276060489.png" alt="CAPTCHA"></p><p><label for="siteguard_captcha">上に表示された文字を入力してください。</label><br /><input type="text" name="siteguard_captcha" id="siteguard_captcha" class="input" value="" size="10" aria-required="true" /><input type="hidden" name="siteguard_captcha_prefix" id="siteguard_captcha_prefix" value="276060489" /></p><p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="送信する" /> <input type='hidden' name='comment_post_ID' value='468' id='comment_post_ID' />
384<input type='hidden' name='comment_parent' id='comment_parent' value='0' />
385</p><p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="f347b405c0" /></p><p style="display: none !important;"><label>&#916;<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="211"/>
385<script>document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() );</script>
385</p></form>	</div><!-- #respond -->
386	</div>
387</article>
388</div></article></main><!-- #box_main 終わり -->
389
390</div><!-- #wrap 終わり -->
391<div id="right_menu">
392
393<div class="adsense_side_top">
394<form action="//www.google.co.jp/cse" id="cse-search-box">
395  <div>
396    <input type="hidden" name="cx" value="partner-pub-0611203521553800:4577309899" />
397    <input type="hidden" name="ie" value="UTF-8" />
398    <input type="text" name="q" size="25" />
399    <input type="submit" name="sa" value="検索" />
400  </div>
401</form>
402
403<script type="text/javascript" src="//www.google.co.jp/coop/cse/brand?form=cse-search-box&amp;lang=ja"></script>
403<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
403
404<!-- 300x250 Excel Side TOP -->
405<ins class="adsbygoogle"
406     style="display:inline-block;width:300px;height:250px"
407     data-ad-client="ca-pub-0611203521553800"
408     data-ad-slot="7670377094"></ins>
409<script>
410(adsbygoogle = window.adsbygoogle || []).push({});
411</script>
411</div>
412
413<aside><div class="aside_area">	<!-- .aside_area 始まり -->
414<div class="aside_border">	<!-- .aside_border 始まり -->
415
416<h4><a href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90" rel="category tag">集計・分析</a></h4>
417<br />
418<b>Warning</b>:  Use of undefined constant date - assumed 'date' (this will throw an Error in a future version of PHP) in <b>/home/kthr01/excel-microsoft.info/public_html/wp-content/themes/excel/sidebar-single.php</b> on line <b>22</b><br />
419<br />
420<b>Warning</b>:  Use of undefined constant ASC - assumed 'ASC' (this will throw an Error in a future version of PHP) in <b>/home/kthr01/excel-microsoft.info/public_html/wp-content/themes/excel/sidebar-single.php</b> on line <b>23</b><br />
421<ul class="submenu">
422<li><a href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/459">表をテーブルに変換すると集計や解析が簡単に行える</a></li>
423<li><a href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/463">Excelで作成したテーブルを元の表に戻す方法</a></li>
424<li><a href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/466">データの並び替え。複数の条件でソート</a></li>
425<li><a href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/471">ピポットテーブルの概要と操作方法</a></li>
426<li><a href="https://excel-microsoft.info/%e9%9b%86%e8%a8%88%e3%83%bb%e5%88%86%e6%9e%90/468">同じ項目をまとめてグループごとに集計</a></li>
427</ul>
428
429</div>	<!-- .aside_border 終わり -->
430
431<div class="ads_side">
432<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
432
433<ins class="adsbygoogle"
434     style="display:block"
435     data-ad-format="fluid"
436     data-ad-layout="image-top"
437     data-ad-layout-key="-8d+1q-e8+e7+jy"
438     data-ad-client="ca-pub-0611203521553800"
439     data-ad-slot="4564982815"></ins>
440<script>
441     (adsbygoogle = window.adsbygoogle || []).push({});
442</script>
442</div>
443
444</div></aside>	<!-- .aside_area 終わり -->
445<br />
446
447
448<nav><div id="nav_area">
449<div class="nav_border">
450<h4>エクセル(Excel)の使い方/カテゴリ</h4>
451<ul class="iconmenu">
452	
453	<li class="nav-scut"><a href="https://excel-microsoft.info/ショートカット">ショートカット</a></li>
454	<li class="nav-input"><a href="https://excel-microsoft.info/入力・書式設定">入力・書式設定</a></li>
455	<li class="nav-edit"><a href="https://excel-microsoft.info/データ編集・加工">データ編集・加工</a></li>
456	<li class="nav-sheet"><a href="https://excel-microsoft.info/シート・ブック">Excelのシート・ブック</a></li>
457	<li class="nav-siki"><a href="https://excel-microsoft.info/数式・計算">数式・計算</a></li>
458	<li class="nav-menu"><a href="https://excel-microsoft.info/メニュー・操作">Excelのメニュー・操作・設定</a></li>
459	<li class="nav-kansu"><a href="https://excel-microsoft.info/関数">Excelの関数</a></li>
460	<li class="nav-print"><a href="https://excel-microsoft.info/印刷">Excelシートを印刷する</a></li>
461	<li class="nav-graph"><a href="https://excel-microsoft.info/グラフ">Excelの表をグラフにする</a></li>
462	<li class="nav-bunseki"><a href="https://excel-microsoft.info/集計・分析">集計・分析</a></li>
463	
464</ul>
465
466<h4>Excelの関数</h4>
467<ul class="func-menu">
468	<li><a href="https://excel-microsoft.info/tag/IF関数">IF関数</a>系(条件分岐する関数)</li>
469	<li><a href="https://excel-microsoft.info/tag/SUM関数">SUM関数</a>系(<a href="https://excel-microsoft.info/tag/合計">合計</a>を求める関数)</li>
470	<li><a href="https://excel-microsoft.info/tag/AVERAGE関数">AVERAGE関数</a>系(<a href="https://excel-microsoft.info/tag/平均値">平均値</a>の関数)</li>
471	<li><a href="https://excel-microsoft.info/tag/COUNT関数">COUNT関数</a>系(個数を<a href="https://excel-microsoft.info/tag/カウント">カウント</a>)</li>
472	<li><a href="https://excel-microsoft.info/tag/MAX関数">MAX関数</a>系(<a href="https://excel-microsoft.info/tag/最大値">最大値</a>を求める関数)</li>
473	<li><a href="https://excel-microsoft.info/tag/MIN関数">MIN関数</a>系(<a href="https://excel-microsoft.info/tag/最小値">最小値</a>を求める関数)</li>
474	<li><a href="https://excel-microsoft.info/tag/ROUND関数">ROUND関数</a>系(四捨五入,切捨て,繰上げ)</li>
475	<li><a href="https://excel-microsoft.info/tag/AND関数">AND関数</a>系(複数の条件で真・偽)</li>
476	<li><a href="https://excel-microsoft.info/tag/エラー">エラー</a> 対処</li>
477</ul>
478
479<h4>Excel用語集</h4>
480<ul class="submenu">
481	<li><a href="https://excel-microsoft.info/tag/オートフィル">オートフィル(連続したデータ)</a></li>
482	<li><a href="https://excel-microsoft.info/tag/条件付き書式">条件付き書式</a></li>	
483</ul>
484
485
486
487<h5>初心者にも分かる使い方サイト</h5>
488	<ul class="iconmenu">
489	<li class="nav-iphone"><a href="https://iphone-itunes.info/">初心者にも分かるiPhoneの使い方</a></li>
490	<li class="nav-ipod"><a href="http://www.ipod-podcast.jp/">初心者にも分かるiPodの使い方</a></li>
491	<li class="nav-repair"><a href="http://修理.iphone-itunes.info/">近くのiPhone修理店</a></li>
492	<li class="nav-excel"><a href="https://excel-microsoft.info/">初心者にも分かるExcelの使い方</a></li>
493	<li class="nav-ppt"><a href="https://powerpoint-microsoft.info/">初心者にも分かるPowerPoint</a></li>
494	<li class="nav-word"><a href="https://word-microsoft.info/">初心者にも分かるWordの使い方</a></li>
495	</ul>
496
497
498
499
500
501
502</div>	<!-- .nav_border 終わり -->
503
504
505<div class="google_kanren">
506<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
506
507<ins class="adsbygoogle"
508     style="display:block"
509     data-ad-format="autorelaxed"
510     data-ad-client="ca-pub-0611203521553800"
511     data-ad-slot="7286514929"></ins>
512<script>
513     (adsbygoogle = window.adsbygoogle || []).push({});
514</script>
514</div>
515
516
517
518
519</div></nav>	<!-- #nav_area 終わり -->
520</div>	<!-- /#right_menu -->
521</div>	<!-- /#contents -->
522
523<footer><div id="footer_area">
524    <div class="copyright">Copyright &#169; エクセル(Excel)の使い方 All Rights Reserved.</div><!-- /.copyright -->
525</div></footer>
526<div class="totop"><a href="#"><img src="https://excel-microsoft.info/wp-content/themes/excel/img/totop.png" alt="ページのトップへ戻る"></a></div><!-- /.totop -->
527</body>
528</html>
529<link rel='stylesheet' id='yarppRelatedCss-css'  href='https://excel-microsoft.info/wp-content/plugins/yet-another-related-posts-plugin/style/related.css' type='text/css' media='all' />

Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.