Average Question

  • Thread starter Thread starter Blake
  • Start date Start date
B

Blake

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.
 
Back
Top