AVERAGE


Explanation of the AVERAGE function

The AVERAGE function will calculate the average of the numbers that you provide as inputs. The image below shows the arguments that the function is asking for:

  1. At least 1 numeric input (required)
  2. Up to a total of 255 numeric inputs (optional)

Note: logical values (TRUE or FALSE) and text values are ignored, however

  • If any of your cells include a 0 value within the range you select, the function will include the 0’s in the calculation bringing down the AVERAGE
  • If any of your cells are blank within the range that you select, those cells will be ignored

It’s important to pay attention to the data you have when using this function so that you can be confident you’re getting the correct results.

AVERAGE function

There are a few different ways you can input values:

  • Single Cell (would just return the same number)
  • Multiple cells selected individually
  • One range of cells
  • Multiple ranges of cells
  • Number values typed directly into the function
  • Named ranges
  • A combination of the above (separated by commas within the function)

In the image below I have manually named range D4:D10 as ‘range2’. The last formula is calculating the AVERAGE of ‘range2’ which is the same as averaging all the numbers in D4:D10.

Quick Average on the Status Bar

If you highlight a range of cells, Microsoft Excel will automatically display the AVERAGE on the status bar. This is a great feature if you quickly need to determine the AVERAGE of a range of values and don’t need to perform any mathematical calculation with it or store the value on your spreadsheet.

In the example below, the status bar is displaying a value of 6:

  • Click into cell B4 and keep the left-mouse button clicked in
  • Drag the mouse cursor down to cell B10
  • Let go of the left mouse button
  • The value will appear in the status bar (as shown in the image below)

Quick Average on status bar

 

Go back to Excel Tutorials.