Reference a cell in criteria range
 

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!

Reference a cell in criteria range
 

Hi Connie

You are very close:

=averageifs(C11:AJ11,B11:BJ11,"=" & C6,B11:BJ11,"<=" & E6)

Regards,
Per

"Connie" skrev i meddelelsen
...
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!

Reference a cell in criteria range
 

On Feb 8, 2:44*pm, "Per Jessen" wrote:
Hi Connie

You are very close:

=averageifs(C11:AJ11,B11:BJ11,"=" & C6,B11:BJ11,"<=" & E6)

Regards,
Per

"Connie" skrev i ...



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!- Hide quoted text -

- Show quoted text -

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)