Average problem

J

jim.campbell3

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
 
J

joeu2004

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top