I need to get the average of a range of cells in an array that are dependant on another cell value. Example - I tried to use

=AVERAGEIFS(B2:B16,A2:A16,"=D2",A2:A16,"<=E2")

but the = isn't seeing the value in the cell D2 so it returns zero. I need to fill in the question marks!! thanks - Jim

depth count Low High Avg Count
1 20 1 5 ?
2 30 6 10 ?
3 40 11 15 ?
4 50
5 60
6 70
7 80
8 90
9 100
10 110
11 120
12 130
13 140
14 150
15 160

wrote:
I tried to use
=AVERAGEIFS(B2:B16,A2:A16,"=D2",A2:A16,"<=E2")
but the = isn't seeing the value in the cell D2 so it returns zero.

That's not the problem. The problem is that the cell references D2 and E2
should not be within the quotes. Try:

=AVERAGEIFS(B2:B16,A2:A16,"=" & D2,A2:A16,"<=" & E2)