View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Omkar
 
Posts: n/a
Default Queation about monthly and weekly averages

I have annual data for concentrations of various species for last
couple of years. I want to find out monthly (12 values) as well as
weekly averages(52 values) for these years.
I did it manually for one year, but its taking lot of time.

Can it be done using single formula and then copying it down the column
to get these values?

Please help me.

Thanks,
Omkar