| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get the AVG price for an entire month
Hello, I need a hand here please...
I have two worksheets, source and destination. The source worksheet has a column of dates listed as 1Jan2003, 2Jan2003, 3Jan2003, (dmmmyyyy) etc. with corresponding prices in the next column. I want to get the AVG of all Jan2003 (mmmyyyy) prices and place it in the destination worksheet in a single row. One row for Feb2003, etc. etc. What's the easiest way to do this? Thanks in advance for your help! - Heather |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct entire month from mmddyyy? | Excel Discussion (Misc queries) | |||
| Please help. Remove dups automaic of same name,price,month. | Excel Discussion (Misc queries) | |||
| Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
| calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
| How do I get the average price per bid for an individual month? | Excel Discussion (Misc queries) | |||
Threaded Mode
