Average Question

[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?

 

[Claus Busch]

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.

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


Regards
Claus Busch

 

[Blake]

Hi Jim,

Am Sat, 30 Apr 2011 04:34:53 -0700 schrieb JimS:



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

Regards
Claus Busch

Thank you

 

[Blake]

Thank you

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?

 

[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?

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


Regards
Claus Busch

 

[Blake]

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

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