Average based on value, not cell location
 

Leith,
Thanks so much for your prompt reply. Unfortunately, I went out of
town after posting...poor planning on my part.

Basically, the table has an ID column first, followed by a column with
the station name. Next is the column for the year of the value, and
finally the value itself. Four columns total, with all the years for
each of the IDs needing to be averaged together. I've attached a
screenshot. Thanks so much for your help.


+-------------------------------------------------------------------+
|Filename: KYCLDD.GIF |
|Download: http://www.excelforum.com/attachment.php?postid=3444 |
+-------------------------------------------------------------------+

--
Klaatt
------------------------------------------------------------------------
Klaatt's Profile: http://www.excelforum.com/member.php...o&userid=23688
View this thread: http://www.excelforum.com/showthread...hreadid=373663