AVERAGEIFS: Reference a cell in a criteria range

  • Thread starter Thread starter Connie
  • Start date Start date
C

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!
 
Do it this way:
=averageifs(C11:AJ11,B11:BJ11,">="&C6,B11:BJ11,"<="&E6)

Regards,
Fred
 
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!
Click to expand...

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

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!
Click to expand...

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