Queation about monthly and weekly averages

[Omkar]

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

 

[Mallycat]

can you post a sample of your data

 

[Guest]

Omkar,

FWIW, I've since responded to your follow on queries in your earlier post,
re: http://tinyurl.com/qkm2r
(detail explanations and a link to a sample file as well <g>)

You should be able to grasp the suggested formula's workings (a single
formula in a starting cell of your choice, then straight copy down), and
modify accordingly to suit ..

 

[Omkar]

Hi Max,

I got it. Since I wasn't clear about *7-6 I chose wrong cells and ended
up in circular references. So I could not get it. But finally I got it.

Thank you very much for help.

Bye.

 

[Guest]

Glad to hear that, Omkar !