Kindly tell me a simple WAY to do it.
Actually i am having daily stock market prices, i just want a simple way to
transfer them into weekly prices.
Say row A has dates and Row B has values.

Week average or ending price for the week?

"Poorak Kashyap" wrote:

Kindly tell me a simple WAY to do it.
Actually i am having daily stock market prices, i just want a simple way to
transfer them into weekly prices.
Say row A has dates and Row B has values.

In C1 enter:
=WEEKNUM(A1) and copy down. for example:

3/1/2008 92 9
3/2/2008 96 10
3/3/2008 100 10
3/4/2008 100 10
3/5/2008 97 10
3/6/2008 104 10
3/7/2008 105 10
3/8/2008 106 10
3/9/2008 109 11
3/10/2008 107 11
3/11/2008 110 11
3/12/2008 107 11
3/13/2008 113 11
3/14/2008 112 11
3/15/2008 108 11
3/16/2008 107 12
3/17/2008 107 12
3/18/2008 116 12
3/19/2008 112 12
3/20/2008 116 12
3/21/2008 118 12
3/22/2008 119 12
3/23/2008 119 13
3/24/2008 118 13
3/25/2008 116 13
3/26/2008 117 13
3/27/2008 123 13
3/28/2008 126 13
3/29/2008 123 13
3/30/2008 124 14

In D1 thru D4 enter:

=SUMPRODUCT(--((C1:C30)=10),B1:B30)/SUMPRODUCT(--((C1:C30)=10))
=SUMPRODUCT(--((C1:C30)=11),B1:B30)/SUMPRODUCT(--((C1:C30)=11))
=SUMPRODUCT(--((C1:C30)=12),B1:B30)/SUMPRODUCT(--((C1:C30)=12))
=SUMPRODUCT(--((C1:C30)=13),B1:B30)/SUMPRODUCT(--((C1:C30)=13))

this will display:

101.1428571
109.4285714
113.5714286
120.2857143

the average price for weeks 10 thru 13
--
Gary''s Student - gsnu200776


"Poorak Kashyap" wrote:

Kindly tell me a simple WAY to do it.
Actually i am having daily stock market prices, i just want a simple way to
transfer them into weekly prices.
Say row A has dates and Row B has values.