Wed 21 Mar 2007, 09:46Delegate Addy said...
Addy has attended:
Excel Advanced course
Excel Intermediate course
Advanced formulas
how to i get an average for a column of figures
Wed 21 Mar 2007, 14:02Trainer Rich said...
Average() function in excel
Hi Addy,
There is an AVERAGE() function in excel which will do this for you.
Simply enter the range in the brackets.
Eg. =AVERAGE(F14:F31)
You can then format the cell that contains the forumla however you like (reduce number of decimal places etc.)
I hope this helps.
Regards, Rich
