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