In Microsoft Excel, the AVERAGE function is used to calculate the arithmetic mean of a range of cells, which is the sum of values divided by the number of values. It is helpful when you want to find the average value of a set of numbers. Here's how to use the AVERAGE function:
Select a cell where you want the average value to be displayed. This cell will be the location of the formula result.
Type the following formula in the formula bar or directly into the selected cell: For example, if you want to find the average of values in cells A1 to A10, the formula would be:
=AVERAGE(A1:A10)
The result will be displayed in the selected cell, showing the arithmetic mean of the specified range.
The AVERAGE function in Excel ignores empty cells, text, and cells with logical values (TRUE/FALSE). If the range contains cells with error values, they are also ignored in the calculation. To find the average of a single cell, simply use the cell reference in the formula. For example, =AVERAGE(A1) will give you the same value as the cell A1.
Ещё видео!