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Å.

 

[Salmon Egg]

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?

You really need to define clearly what is meant by average price. Is it
the price averaged over time? Is it averaged of units sold? Is over
offers? As requested, I would take it to mean the sum of daily price
listings divided by the number of days of these offerings.

Bill