Hi, I want to find the average in column B for the last 14 calendar
days. In other words, 12/29-12/16. How would I do that?

12/10/11 $325.00
12/11/11 $322.00
12/12/11 $225.00
12/15/11 $278.80
12/16/11 $227.30
12/17/11 $301.30
12/18/11 $273.70
12/19/11 $201.90
12/29/11 $291.13

It would be a lot easier if your date list did not skip any dates.
A9 = 12/16/2011
A22 = 12/29/2011
Column B has the amounts
Then...
=AVERAGE(OFFSET(B22,-13,0,14,1))
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(Bingo Card Variety .xls workbook - in the free folder)




"Blake"
wrote in message
...
Hi, I want to find the average in column B for the last 14 calendar
days. In other words, 12/29-12/16. How would I do that?

12/10/11 $325.00
12/11/11 $322.00
12/12/11 $225.00
12/15/11 $278.80
12/16/11 $227.30
12/17/11 $301.30
12/18/11 $273.70
12/19/11 $201.90
12/29/11 $291.13

On Tue, 10 Jan 2012 18:49:47 -0800 (PST), Blake wrote:

Hi, I want to find the average in column B for the last 14 calendar
days. In other words, 12/29-12/16. How would I do that?

12/10/11 $325.00
12/11/11 $322.00
12/12/11 $225.00
12/15/11 $278.80
12/16/11 $227.30
12/17/11 $301.30
12/18/11 $273.70
12/19/11 $201.90
12/29/11 $291.13

If you have Excel 2007: =AVERAGEIF(A:A,""&MAX(A:A)-14,B:B)

Earlier versions: =SUMIF(A:A,""&MAX(A:A)-14,B:B)/COUNTIF(A:A,""&MAX(A:A)-14)

On Jan 10, 7:47*pm, Ron Rosenfeld wrote:
On Tue, 10 Jan 2012 18:49:47 -0800 (PST), Blake wrote:
Hi, I want to find the average in column B for the last 14 calendar
days. *In other words, 12/29-12/16. *How would I do that?

12/10/11 * *$325.00
12/11/11 * *$322.00
12/12/11 * *$225.00
12/15/11 * *$278.80
12/16/11 * *$227.30
12/17/11 * *$301.30
12/18/11 * *$273.70
12/19/11 * *$201.90
12/29/11 * *$291.13

If you have Excel 2007: *=AVERAGEIF(A:A,""&MAX(A:A)-14,B:B)

Earlier versions: * =SUMIF(A:A,""&MAX(A:A)-14,B:B)/COUNTIF(A:A,""&MAX(A:A)-14)

Hi, and thanks.

This formula works fine: =AVERAGEIF(A:A,""&MAX(A:A)-14,B:B)

This formula I could not get to work:
=AVERAGE(OFFSET(B22,-13,0,14,1))

Thanks for the quick responses.

On Tue, 10 Jan 2012 21:24:53 -0800 (PST), Blake wrote:

Hi, and thanks.

This formula works fine: =AVERAGEIF(A:A,""&MAX(A:A)-14,B:B)

This formula I could not get to work:
=AVERAGE(OFFSET(B22,-13,0,14,1))

Thanks for the quick responses.

Glad to help. Thanks for the feedback.

I did not test Jim's formula, but I suspect it is not working because your data is not set up exactly as he described.