The AVERAGE function.
To be technically accurate, no function does this. The answer you are looking for is the AVERAGE function. It divides by the amount of cells that have values in them, not by the amount of cells. In most situations, all of the selected cells have values in them, but there are cases when they don't.
The AVERAGE function.
AVERAGE(range)
The Average function. For example, to get the mean of the cells from A2 to A15, you would use it this way: =AVERAGE(A2:A15)
SUM
SUM function
A colon would be between the two cell references that make a range like in these: =SUM(B2:B10) =AVERAGE(V20:X23)
You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)
A range can be one of the arguments in a function. It can also be an array of values. It depends on the function and what it needs to work.
The Average function in Excel will help you calculate the average, or more specifically the arithmetic mean. Excel's average function checks all the number in a given range and calculates the average of them, by adding the values and dividing by the amount of values. Cells with no data will not be included in the calculation. The Average function looks like this =AVERAGE(number1,number2) where each number can be a reference for a cell or range of cells or can be entered manually. For example =AVERAGE(50,100) equals 75.
The most basic function in Excel is SUM() Other functions are AVERAGE, MIN, MAX
SUM(1st range, [optional 2nd range], [optional 3rd range], [& so on])