How to find the average in excel?

June 15, 2022
1.2K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

You may not stop wondering how to find the average in your existing Excel document and want to solve that question as soon as possible. Taking a math average from Excel could be very relevant to your growing company. However, you may not have the slightest idea how to apply these formulas, so that you will need help.


It's time for you to learn how to find the average of numbers simply and safely. After completing these methods for finding the average, you'll have everything you need to excel in Excel.


How to calculate the average in Excel using the ribbon option?

If you want to use an effective formula for average, you should use the ribbon option. To extend this method, you must do the following:


1、Open your Excel spreadsheet and select the cells you want to average.


2、In the options menu, you must click on the start tab next to the file tab.


3、Go to the editing group and click on the sum option. You could also use the command Alt + =


4、A new box will open where the sum and average options appear. You will have to click on average.


5、The cells you previously selected will automatically be averaged.


How to calculate the average in Excel where zeros are included?


If you are looking for how to find the average in math where zeros are included, you will have to do the following:


1、Again, open the spreadsheet in Excel and select the cell where you want the final average to be reflected.


2、Inside the cell, you must write =AVERAGE(C2:C5). It would help if you considered that the numbers established in the cells C2 and C5 will depend on how large your calculation is. If the numbers are in non-continuous cells, you must specify each one, for example, C2:C5:C8.


3、Now, just hit enter for the average to show up.


How to calculate the average in Excel, excluding zeros?


You might also be interested in learning how to find the average where zeros are excluded. But to apply this method, you must do the following:


1、You must open the Excel document you want to average and select the cell where you want the final result to appear.


2、Inside the cell, you will have to write the function =AVERAGEIF(C2:C5,>0). It would help if you considered that the cell number varies according to what you have established in your spreadsheet.


3、You only have to press Enter for Excel to return the final average without zeros.


It will be very easy for you to know how to find the average rate of change if you comply with each of the methods indicated. It will help if you become a professional using Excel to excel at work. It is good that you put each of these methods into practice so that you never forget how to find the average but apply it smoothly.


If the information on finding the average has been useful to you and you want to have more similar guides, do not forget to go to WPS Academy. With the website, you will have information of interest about the tools available in Excel, Word, and PowerPoint. On the other hand, you can download the WPS Office software at no cost.