{"id":415347,"date":"2022-03-12T19:00:41","date_gmt":"2022-03-12T16:00:41","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-calculate-average-in-google-sheets\/"},"modified":"2022-03-12T19:00:41","modified_gmt":"2022-03-12T16:00:41","slug":"how-to-calculate-average-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-average-in-google-sheets\/","title":{"rendered":"#How to Calculate Average in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2dbcd31a510\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2dbcd31a510\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-average-in-google-sheets\/#%E2%80%9CHow_to_Calculate_Average_in_Google_Sheets%E2%80%9D\" >&#8220;How to Calculate Average in Google Sheets&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-average-in-google-sheets\/#View_a_Quick_Average\" >View a Quick Average<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-average-in-google-sheets\/#Use_the_Functions_Button\" >Use the Functions Button<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-average-in-google-sheets\/#Enter_the_Function_Manually\" >Enter the Function Manually<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Calculate_Average_in_Google_Sheets%E2%80%9D\"><\/span>&#8220;How to Calculate Average in Google Sheets&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Calculating an average is one of the basic equations you might need in your spreadsheet. Google Sheets offers a few different ways to average numbers or cells.<\/p>\n<p>You may use Google Sheets to keep track of grades for your students or sales for your company. When you want to get an average of a group of cells, specific numbers, or a combination of both, you have options to pick the best method for you. Let\u2019s take a look.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"View_a_Quick_Average\"><\/span>View a Quick Average<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Google Sheets provides a few <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/746366\/how-to-see-basic-calculations-without-formulas-in-google-sheets\/\">calculations that you can view at a glance. If you don\u2019t want to add the average of your cells to your sheet, but simply see it, this is ideal.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to See Basic Calculations Without Formulas in Google Sheets<\/em><\/strong><\/p>\n<p>Select the cells containing the numbers you want to average. Then, look down on the bottom right corner of Google Sheets. You\u2019ll see a box containing a basic calculation, likely Sum.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789011\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/ViewSum-GoogleSheetsAverage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"View the sum at a glance\" width=\"650\" height=\"274\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click the arrow to display the other options and you\u2019ll see the average.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789003\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/ViewAverage-GoogleSheetsAverage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"View the average at a glance\" width=\"650\" height=\"293\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you plan to adjust your numbers or view the average for another set of cells, you can select the average to keep it displayed in the box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789002\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/KeepAverage-GoogleSheetsAverage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Keep the average displayed\" width=\"650\" height=\"290\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_Functions_Button\"><\/span>Use the Functions Button<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/768481\/how-to-calculate-average-in-microsoft-excel\/\">add the average to your sheet, you can do this using the Functions button in the toolbar.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Calculate Average in Microsoft Excel<\/em><\/strong><\/p>\n<p>Select the cells containing the numbers that you want to average. Click the arrow next to the Functions button to view the available calculations and pick \u201cAverage.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789006\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/FunctionsButton-GoogleSheetsAverage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Average in the Functions button list\" width=\"650\" height=\"122\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll the temporary spot for the function which is at the bottom of a column or furthest right of a row. Confirm that the range selected is correct in the formula and press Enter or Return.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789005\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/FunctionsButtonAverage-GoogleSheetsAverage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Average formula using the Functions button\" width=\"650\" height=\"112\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The average formula is then added to the cell for you.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789004\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/FunctionsButtonKeepAverage-GoogleSheetsAverage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Keep the average on the sheet\" width=\"650\" height=\"113\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Enter_the_Function_Manually\"><\/span>Enter the Function Manually<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe you want to get an average of nonadjacent cells, numbers, or a combination of cells and numbers. In this case, entering the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/777809\/basic-google-sheets-functions\/\"><code>AVERAGE<\/code> function manually is your best bet. This gives you the flexibility to add what you need to the formula.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>9 Basic Google Sheets Functions You Should Know<\/em><\/strong><\/p>\n<p>The syntax for the function in Google Sheets is <code>AVERAGE(value1, value2,...)<\/code> where <code>value1<\/code> is required and <code>value2<\/code> is optional.<\/p>\n<p>Select the cell where you want to display the average. For this first example, we\u2019re going to average two nonadjacent groups of cells, B2 through B12 and E2 through E12. You would enter the following formula replacing the cell references with your own.<\/p>\n<pre>=AVERAGE(B2:B12,E2:E12)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-789007 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/AverageFunctionCells-GoogleSheetsAverage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Average function for groups of cells\" width=\"650\" height=\"339\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If the numbers you want to average do not exist within cells, you can simply enter those numbers into the formula to obtain their average.<\/p>\n<pre>=AVERAGE(5,10,15,20,100,120)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-789013 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/AverageFunctionWithNumbers-GoogleSheetsAverage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Average function for numbers\" width=\"600\" height=\"179\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also combine cells and numbers in the formula. Here we\u2019ll average numbers 10 and 15, the cell range B2 through B12, and cell E12 using the following.<\/p>\n<pre>=AVERAGE(10,15,B2:B12,E12)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789009\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/AverageFunctionCellsNumbers-GoogleSheetsAverage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Average function for groups of cells plus numbers\" width=\"650\" height=\"342\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>With different options to calculate an average in Google Sheets, you can pick the one that best fits your needs.<\/p>\n<p>Be sure to take a look at how to multiply numbers in Google Sheets or how to use the <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">MEDIA<\/a>N function too.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/788999\/how-to-calculate-average-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Calculate Average in Google Sheets&#8221; Calculating an average is one of the basic equations you might need in your spreadsheet. Google Sheets offers a few different ways to average numbers or cells. You may use Google Sheets to keep track of grades for your students or sales for your company. When you want&#8230;<\/p>\n","protected":false},"author":1,"featured_media":415348,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-415347","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/415347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=415347"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/415347\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/415348"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=415347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=415347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=415347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}