Excel Average Formula, Function, Average Cells in Excel

The Excel Average (Average) function will identify the Average of a range of cells.
Select the cell where in you want the formula to be entered. (Cell B14)
Next Click on the Sigma  ∑ sign.  The drop down menu will give you a choice of functions – select Average.
The formula =Average(number1,[number2]….etc, Select range of cells, hit Enter Key.
Or type the formula =Average(B2:B13)  in the example shown below.

Excel07 Average

Advertisements
Explore posts in the same categories: Excel - Helpful Hints & Tips

Tags: , , , , , , , , , , , , , , , , , , , ,

You can comment below, or link to this permanent URL from your own site.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: