answersLogoWhite

0

Use the formula =AVERAGE(<cell range>), where <cell range> comprises the cells to be averaged.

Example:

A1 = 2, A2 = 4, A3 = 6, A4 = 8

In cell B1 (or any other blank cell), type =AVERAGE(A1:A4) and press enter. Excel will replace the formula with the number 5.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

Which Excel tool would you use to help you find just the right word?

The right word for what?? Excel is a spreadsheet used to crunch numbers and get results by using formulas, if you want to write a paper use Word.......


How do you find the average of 5 numbers using static method in java?

Add the five numbers; divide the result by 5.


How do you find the mean of a set of numbers in excel?

In the cell where you want the mean to appear, write =AVERAGE(description of the cells containing the group of numbers) Or, when you have typed '=AVERAGE(', highlight the cells that you want to be in the set. This is easier instead of typing it in. Remember to close parentheses!


Do the lookup tables in excel not find letters only numbers?

They can be used to search for both letters and numbers.


What function would you use to find the mean in a Microsoft Excel document?

The AVERAGE function returns the average (arithmetic mean) of the numbers provided.=AVERAGE(number1,number2,...number_n)number1, number2, ... number_n are numeric values. They can be numbers, named ranges, arrays, or references to numbers. You can enter up to 30 values.


What is the formula to find the sum of cells a1 a2 and a3 in excel?

Excel formulas that will find the average of cells A1, A2, and A4 are: =AVERAGE(A1 ,A2, A4) or =AVERAGE(A1:A2, A4)


How do you do average of a lot of numbers?

To find the average of a list of numbers, add the numbers and divide by the number of numbers in the list.


How do you find the average of n numbers?

The average of n numbers = (sum of n numbers) / (count of n numbers).


If The average of 5 numbers is 6 and the average of 3 numbers is 4 find out the average of remaining two numbers?

2


How do you use the four operations and find averages on numbers on an Excel spreadsheet?

The four basic operations are:+ for addition- for subtraction* for multiplication/ for divisionTo calculate an average, you can use the average() function. Type:=average(then select a range of cells with the mouse. Finish by closing parentheses.


Where could I find an amortization calculator for excel?

You may find an amortization calculator for excel at http://office.microsoft.com/en-us/excel-help/using-the-loan-amortization-and-loan-analysis-templates-HA001034640.aspx.


Which menu contains the Find and Replace commands when using Excel?

The Edit menu.