Reference a cell in criteria range

[Connie]

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!

 

[Per Jessen]

Hi Connie

You are very close:

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

Regards,
Per

 

[Connie]

Hi Connie

You are very close:

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

Regards,
Per

"Connie" <[email protected]> skrev i meddelelsen








- 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)