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!