To use the formula
for consecutive numbers:
-Type
'=average(Number1:Number2)'
-Press
Enter
-Example
1:
-In
this example I want to average the total units for Sunday through Saturday in
cell B9
-In
cell B9 type '=average(B2:B8)'
-Press
Enter
-Now
you will see the result of 5
-To
see the formula, click back into cell B9 and you will see the formula in the
Formula Bar
To use the formula
for non-consecutive numbers:
-Type
'=average(Number1,Number2)'
-Press
Enter
-Example
2:
-In
this example I want to average the total units for Sunday and Saturday in cell
B9
-In
cell B9 type '=average(B2,B8)'
-Press
Enter
-Now
you will see the result of 5
-To
see the formula, click back into cell B9 and you will see the formula in the
Formula Bar
To use the formula
for consecutive and non-consecutive numbers:
-Example
3:
-In
this example I want to average the units for Friday, Saturday and Sunday in
cell B9
-In
cell B9 type '=average(B2,B7:B8)'
-Press
Enter
NOTE: The difference between
the consecutive and non-consecutive numbers is the difference of using either '
: ' or ' , '. For consecutive numbers, use the ' : ' between the first
and last number. For non-consecutive numbers, use a ' , ' between the numbers.
-Now
you will see the result of 4
-To
see the formula, click back into cell B9 and you will see the formula in the
Formula Bar
As I explained with
the Sum formula, there are multiple ways to insert the average formula into the
spreadsheet.
1.
Type the formula in as described above
2.
Use the "Insert Icon" function and type in 'Average' (Follow the same steps as in the Sum formula post)
3.
On the Home tab, in the Editing section, click the AutoSum function drop down
menu
-Click
Average
4.
On the Formulas tab, in the Function Library Section, click on the AutoSum
function drop down menu
-Click
Average
The 3rd and 4th options work best for summing
consecutive cells. That being said, you can make adjustments to the formula to
sum non-consecutive cells or a combination of both.
Excel ya later!
No comments:
Post a Comment