I want to average a range if 2 criteria are met; the criteria includes
cell references:

C6 = 1/1/2009 (internal date)
E6 = 1/1/2010 (internal date)

Cells B11:BJ11 contain valid dates
Cells C11:AJ11 contain valid numbers

I want to average the values in C11:AJ11 that are >= C6 and <= E6.
Can I reference the cells in the criteria range?

I used averageifs(C11:AJ11,B11:BJ11,">=C6",B11:BJ11,"<=E6 ") which of
course did not work.

Thanks!

Do it this way:
=averageifs(C11:AJ11,B11:BJ11,">="&C6,B11:BJ11,"<= "&E6)

Regards,
Fred

"Connie" <(E-Mail Removed)> wrote in message
news:606ab8bf-6508-413d-ace7-(E-Mail Removed)...
>I want to average a range if 2 criteria are met; the criteria includes
> cell references:
>
> C6 = 1/1/2009 (internal date)
> E6 = 1/1/2010 (internal date)
>
> Cells B11:BJ11 contain valid dates
> Cells C11:AJ11 contain valid numbers
>
> I want to average the values in C11:AJ11 that are >= C6 and <= E6.
> Can I reference the cells in the criteria range?
>
> I used averageifs(C11:AJ11,B11:BJ11,">=C6",B11:BJ11,"<=E6 ") which of
> course did not work.
>
> Thanks!

On Feb 8, 12:16*pm, Connie <connie.maldon...@softkeyinc.com> wrote:
> I want to average a range if 2 criteria are met; the criteria includes
> cell references:
>
> C6 = 1/1/2009 * *(internal date)
> E6 = 1/1/2010 * *(internal date)
>
> Cells B11:BJ11 contain valid dates
> Cells C11:AJ11 contain valid numbers
>
> I want to average the values in C11:AJ11 that are >= C6 and <= E6.
> Can I reference the cells in the criteria range?
>
> I used averageifs(C11:AJ11,B11:BJ11,">=C6",B11:BJ11,"<=E6 ") *which of
> course did not work.
>
> Thanks!

Thanks. That was a great help. I was able to get the formula to
work
using the following (I noticed there was an error in the formula in
my
original message):

AVERAGEIFS($C11:$AI11,$C$10:$AI$10,">="&$C$6,$C$10 :$AI$10,"<="&$E$6)

Glad to help. Thanks for the feedback.

Fred

"Connie" <(E-Mail Removed)> wrote in message
news:0adbd02a-cf88-4342-bed5-(E-Mail Removed)...
On Feb 8, 12:16 pm, Connie <connie.maldon...@softkeyinc.com> wrote:
> I want to average a range if 2 criteria are met; the criteria includes
> cell references:
>
> C6 = 1/1/2009 (internal date)
> E6 = 1/1/2010 (internal date)
>
> Cells B11:BJ11 contain valid dates
> Cells C11:AJ11 contain valid numbers
>
> I want to average the values in C11:AJ11 that are >= C6 and <= E6.
> Can I reference the cells in the criteria range?
>
> I used averageifs(C11:AJ11,B11:BJ11,">=C6",B11:BJ11,"<=E6 ") which of
> course did not work.
>
> Thanks!

Thanks. That was a great help. I was able to get the formula to
work
using the following (I noticed there was an error in the formula in
my
original message):

AVERAGEIFS($C11:$AI11,$C$10:$AI$10,">="&$C$6,$C$10 :$AI$10,"<="&$E$6)