From: Brad Loomis <[log in to unmask]>
Subject: How do I do this in Excel??
To produce averages from a range of data (miles, gallons etc.) on
one sheet to appear on a second sheet.
Click in the cell where you want the average to appear, type
=AVERAGE(
then with your mouse click on the first sheet and highlight the
range of data you want averaged, including plenty of blank cells for
future data. Tap return then type the closing bracket ) to the
average function and it should work.
Regards
Tony
(Tony Beckett, Rutland, UK)
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://nospin.com/pc/pcsoft.html
|