Hi there,

I'm trying to use AVERAGEIFS to take the average of the values in a column that are > a low cutoff value and < a high cutoff value.

In my sheet, the cutoff values are calculated in two cells, and I need to refer to those values in my AVERAGEIFS formula.

Here's what I've tried so far:

=AVERAGEIFS(H2:H81,H2:H81,">B10",H2:H81,"<B11")

This gives me a #DIV/0! error.

If I replace the cell references in the criteria clauses (">B10" and "<B11") I get the correct answer, so I guess it's not handling these sections correctly.

Can anyone tell me what I'm missing?

Thank you!

Zoe