Average Question

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

Dates are in column B
Prices are in column C

I want cell D1 to show the average price for the last two weeks even
though I'm adding new data every day.

How do I do that?
 
Hi Jim,

Am Sat, 30 Apr 2011 04:34:53 -0700 schrieb JimS:
Dates are in column B
Prices are in column C

I want cell D1 to show the average price for the last two weeks even
though I'm adding new data every day.
Click to expand...

=AVERAGE(OFFSET($C$1,COUNTA($C:$C)-1,,-14))


Regards
Claus Busch
 
Am Sat, 30 Apr 2011 08:06:45 -0700 (PDT) schrieb Blake:
Actually, I need to do the same thing, but how would you change the
formula if you started the data for your two columns in row 13?
Click to expand...

=AVERAGE(OFFSET($C$13,COUNTA($C$13:$C$10000)-1,,-14))


Regards
Claus Busch
 
Am Sat, 30 Apr 2011 08:06:45 -0700 (PDT) schrieb Blake:


=AVERAGE(OFFSET($C$13,COUNTA($C$13:$C$10000)-1,,-14))

Regards
Claus Busch
Click to expand...

Aha! The $C$10000 is the part I couldn't figure out. Mucho ArigatÅ.
 
Back
Top