AVERAGEIFS using a cell reference in the criteria

Using the formula =AVERAGEIFS(WORKSHEET!V5:V35,WORKSHEET!B5:B35,">=A43",WORKSHEET!B5:B35,"<=C43") returns a #DIV0! error. I need to average the numbers in column V that fall into the date range between cells A43 and c43. The problem appears to be with using ">=A43" and "<=C43" because if i substitute numbers for the cell reference it works.

Use ">="&A43, etc


Regards, TMS

Hello John,

you are almoste there. Just change the formula to,

=AVERAGEIFS(WORKSHEET!V5:V35,WORKSHEET!B5:B35,">="&A43,WORKSHEET!B5:B35,"<="&C43)

If you use cell references inside the quotes, this will consider as text NOT cell references.