AVERAGE function

AVERAGE
function
Use the AVERAGE function to get the average of numbers in a range of cells. Fruit Amount Meat Amount
Select cell D7,the
Use then use AutoSum
AVERAGE toto
function add
getanthe
AVERAGE function.
average of numbers in a range of cells. Apples 50 Beef 50 CHECK THIS OUT
Now select cell G7, and enter an AVERAGE function by typing =AVERAGE(G3:G6). Oranges 20 Chicken 30 Select any range of numbers,
In cell D15, 1you can
Select
use cell D7,AutoSum,
either then use AutoSum
or type to to addanother
enter an AVERAGE
AVERAGEfunction.
function. Bananas 60 Pork 10 then look in the Status Bar for an
instant Average.
CHECK THIS Lemons 40 Fish 50
Activate the previous sheet AVERAGE > AVERAGE >
2
Go to the next sheet
Now select cell G7, and enter an AVERAGE function by typing
EXTRA CREDIT =AVERAGE(G3:G6).
Item Amount Item Amount
Links for more information on the web Bread 50 Bread 50
3 In cell
Select to learn all about D15, youfunction
the AVERAGE can useon either
the webAutoSum, or type to enter another AVERAGE Donuts 100 Donuts 100
function.
Select to learn all about the MEDIAN function on the web Cookies 40 Cookies 40
Select to learn all about the MODE function on the web Cakes 50 Cakes 50
Select to learn about free Excel training on the web Pies 20 Pies 20
Previous Next AVERAGE >

EXTRA CREDIT
Try using MEDIAN or MODE here.
More information on the web
MEDIAN gives you the value in the
All about the AVERAGE function middle of the data set, while
MODE gives the one that occurs
All about the MEDIAN function the most frequently.

All about the MODE function

Free Excel training online

More about the SUM function

In some of the above tips, we taught you how to use the SUM function. Here are more details about it.
Cells C37 through D41 contain data with two columns: Fruit and Amount.
The formula in cell D42: =SUM(D38:D41).
If the SUM function in cell D42 could talk, it would say this: Sum up the values in cells D38, D39, D40, and D41.
Here's another way it can be used:
Cells C47 through D48 contain data with two columns: Item and Amount.

More information on the web

All about the SUM function
All about the SUMIF function
Use Excel as your calculator
Free Excel training online
Go back to top by pressing CTRL+HOME. To proceed to the next step, press CTRL+PAGE DOWN.
 MIN and MAX functions
MIN and MAX functions
Use the MIN function to get the minumum number in a range of cells. Fruit Amount Meat Amount
Use the MAXUse the MIN
function function
to get to get
the maximum the smallest
number in a rangenumber
of cells. in a range of cells. Apples 50 Beef 50
Use the MAX function to get the largest number in a range of cells.
then use the Oranges 20 Chicken 30
G7, and enter a Bananas 60 Pork 10
1
can use either Select cell D7, then use the AutoSum Wizard to add a MIN function. Lemons 40 Fish 50
information on MIN > MAX >
All aobut the MIN function
2 Now select cell G7, and enter a MAX function by typing =MAX(D3:D6).
All about the MAX function Item Amount Item Amount
Free Excel training online Bread 50 Bread 50

3
KNOW Donuts 100 Donuts 100
In cell D15, you can use either the AutoSum Wizard, or type to enter a MIN or
Cookies 40 Cookies 40
MAX function.
Cakes 50 Cakes 50
Pies 20 Pies 20
MIN or MAX > 10

GOOD TO KNOW

More information on the web

You can use either MIN or MAX with multiple
You can use either MIN or MAX with multiple ranges, or values to show the greater or lesser of those values, like =MIN(A1:A10,B1:B10), or =MAX(A1:A10,10).
ranges, or values to show the greater or lesser of
those values, like =MIN(A1:A10,B1:B10), or
More information on the web
All about the MIN function
All about the MIN function
=MAX(A1:A10,B1), where B1 contains a threshold
value, like 10, in which case the formula would
All about the MAX function
All about the MAX function never return a result less than 10.
Use Excel as your calculator
Free Excel training online
Free Excel training online