+5 votes
81 views
How to calculate the average in Microsoft Excel

in Guides by (552k points)
reopened | 81 views

1 Answer

+3 votes
Best answer

What is the average?
How to calculate average in Excel

One of the options that Microsoft Excel has is to calculate the average of several numbers. This function can be useful in a great number of occasions and just a little further down, we are going to show you a very simple method so that you can put it into practice..

We have already taught you several things related to Microsoft Excel such as saving a graph as an image, crossing out text, dividing cells, protecting our files with a password, etc. We have many guides related to this interest and above all, a useful program.

In this article, we will see how to calculate the average in the fastest and most effective way possible. Every time we use Excel, one of the things we need the most is to save time and we can perform our tasks quickly, this guide is designed for just that..

What is the average?

The average of the numerical values ​​is calculated by adding all the numbers and dividing the sum of them by the count of numbers.

We are going to give an example so that they are better understood, if the numbers are 10, 15, 20, 25 and 30, the first thing will be to add all those numbers and then divide that sum by 5 because obviously, we have a total of five numbers. Basically it would be 10 + 15 + 20 + 25 + 30/5 = 20

By default, when Excel performs the calculation it ignores those cells that are blank, it will also ignore cells that have zero..

How to calculate average in Excel

image

The first thing we will have to do is open the spreadsheet that contains the numbers in Excel. In the spreadsheet, we are going to have to choose the numbers for which we want to find the average.

image

In the Excel toolbar, we are going to go to the "Home" tab.

image

Next, we go to the "Edition" section and we will have to select the icon with the down arrow next to "Sum".

image

A new menu will expand where we will have to look for the option that says "Average" to be able to find the average of its numbers.

image

At the end of the selected cells, we will be able to see the average of the numbers that we have previously selected.



by (3.5m points)
edited

Related questions

+5 votes
1 answer
asked Sep 17, 2019 in Office by backtothefuture (552k points) | 313 views
+4 votes
1 answer
asked Nov 11, 2022 in Guides by backtothefuture (552k points) | 74 views
+3 votes
1 answer
asked Nov 21, 2021 in Guides by backtothefuture (552k points) | 103 views
+5 votes
1 answer
asked Nov 15, 2021 in Guides by backtothefuture (552k points) | 106 views
+3 votes
1 answer
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users