Average Question
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.
|