View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Extropian Extropian is offline
external usenet poster
 
Posts: 3
Default 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