| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do I? Perform simplae Average on a indexed text location | Excel Discussion (Misc queries) | |||
| Show value from specific column based on location of active cell | Excel Discussion (Misc queries) | |||
| Average If - averaging cells based on value of another cell | Excel Worksheet Functions | |||
| average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
| Sum Based on Cell location in Column | Excel Programming | |||
Threaded Mode
