When using the AVERAGE function, bear the following in mind. If typing the cell references directly into the cell or formula bar, non-contiguous references are separated by commas. In order to calculate the average of non-contiguous (non-adjacent) cells, simply hold the Control key (or Command key - Mac users) while making the selections. This can be typed directly into the cell or formula bar, or selected on the worksheet by selecting the first cell in the range, and dragging the mouse to the last cell in the range. To calculate the average of values in cells B2, B3, B4, and B5 enter: = AVERAGE ( B2 : B5 ) The formula below will calculate the average of the numbers 100, 95, and 80. Only one argument is required, but of course, if you’re using the AVERAGE function, it’s likely you have at least two.
The AVERAGE function can handle up to 255 arguments, each of which may be a value, cell reference, or range.
Ranges or cell references may be used instead of explicit values.
The AVERAGE function in Excel is straightforward.
