• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Google Sheets: How to Get the Average on Any Numbers

Google Sheets: How to Get the Average on Any Numbers

August 15, 2022 by Judy Sanhz Leave a Comment

You’re working on something where you need to calculate the average of the numbers you enter. Sure, you can try and calculate it yourself, but there is no need to do that since Google Sheets can do it for you. It doesn’t matter if you have a lot of little numbers to calculate. You can choose from three different options when it comes to getting the average of certain numbers.

How to Calculate the Average in Google Sheets

Once the Google Sheets file is open, select the numbers you want to get the average to. You’ll see the sum of the numbers at the bottom right of your display as soon as you let go. Click on the dropdown menu next to the numbers.

Google Sheets Average

When you click on the dropdown menu, you’ll see various options. The average will be the second one from the top.

Google Sheets average

You’ll only see the average if you have the cells highlighted. If you click somewhere else, the average will disappear. There is another way you can calculate the average without leaving Google Sheets. Once again, you’ll need to highlight the numbers, and at the bottom right, click on the Explore option.

Explore option Google Sheets

When you click on it, you’ll see different options. The average will be the second one from the top.

Explore average Google Sheets

If you need to edit anything, click on the Edit option. You can do things such as change the data range and the headers.

Edit average range Sheets

You can also turn your information into charts. Choose the one you like the most and place the cursor a the top right corner of the chart. You should see an option to add the chart appear.

Google Sheets Chart

Average Function

Suppose you want to have more control over how the average is calculated. In that case, you can always go with the average formula. Make sure you have the Google Sheets file open. Find an empty cell and enter the following function, =average (A1:B7).

When you first start typing average, the option to select it will appear to click on it, and then with your mouse, select the range you want to get the average for. Suppose you don’t feel like using that option. In that case, you can always enter the cells manually, but remember to add a closing parenthesis to close it.

Average function Google Sheets

Conclusion

Those are your three options if you want to calculate the average of numbers without having to use a third-party app. You can go with the option you feel more comfortable with and get the information you need. Which option do you think you’re going to try first? Share your thoughts in the comments below, and don’t forget to share the article with others on social media.

You Might Also Like

  • Google Sheets: How to Round Numbers
    Google Sheets: How to Round Numbers
  • Google Sheets: How to Use the Google Translate Formula
    Google Sheets: How to Use the Google Translate Formula
  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes Blank
    Troubleshooting Google Sheets Goes Blank
  • Google Sheets Won't Let Me Type - Fix Guide
    Google Sheets Won't Let Me Type - Fix Guide

Filed Under: Internet Tagged With: Google Sheets

Reader Interactions

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • How to Print Labels from Excel Using MS Word Mail Merge
  • What Is NVMe Over TCP (NVMe/TCP)
  • Android Mobile Hotspot: How to Change the Password and Name
  • Windows 10: How to Force Quit and App
  • What is Dumpster Diving?
  • How to Download iOS 16 Beta 3 on iPhone or iPad
  • What is a Security Compromise?
  • Mastodon: How to DM Someone

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy