Finding MIN, MAX, and average
 

Hey all

I am having a problem finding a quick way to get the average, minimum
and maximum for the data i have. attached is a sample of the data
am working with. it will continue like this for each month of th
year. I need to find average, Minimum, and Maximum as shown in th
attached file for each month. The number of years may also change fo
each station. Any help on this matter will be greatly appreciated.
:

+-------------------------------------------------------------------
|Filename: sample data.doc
|Download: http://www.excelforum.com/attachment.php?postid=2705
+-------------------------------------------------------------------

--
jim hense
-----------------------------------------------------------------------
jim hensen's Profile: http://www.excelforum.com/member.php...fo&userid=1515
View this thread: http://www.excelforum.com/showthread.php?threadid=26788

Finding MIN, MAX, and average
 

Use Data=Subtotal

--
Regards,
Tom Ogilvy

"jim hensen" wrote in message
...

Hey all

I am having a problem finding a quick way to get the average, minimum,
and maximum for the data i have. attached is a sample of the data i
am working with. it will continue like this for each month of the
year. I need to find average, Minimum, and Maximum as shown in the
attached file for each month. The number of years may also change for
each station. Any help on this matter will be greatly appreciated.
:)


+-------------------------------------------------------------------+
|Filename: sample data.doc |
|Download: http://www.excelforum.com/attachment.php?postid=2705 |
+-------------------------------------------------------------------+

--
jim hensen
------------------------------------------------------------------------
jim hensen's Profile:
http://www.excelforum.com/member.php...o&userid=15155
View this thread: http://www.excelforum.com/showthread...hreadid=267886