E
Evan
I'm trying to use the AVERAGEIFS function to average a range of numbers if
the numbers are greater than the value in one cell and less than the value in
another cell. However when I try to reference specific cells as the criteria
in the formula I get a #DIV/0! error.
The formula reads: =AVERAGEIFS(B3:B15,B3:B15,">B18",B3:B15,"<B19")
IN this case B3:B15 are:
23
31
17
35
41
30
23
34
29
26
29
20
34
And B18 is 22 and B19 is 35
If I replace B18 with 22 and B19 with 35 in the forumla,
i.e. =AVERAGEIFS(B3:B15,B3:B15,">22",B3:B15,"<35")
it calculates correctly with no error.
Why can't a refence those cells as the criteria??? Thanks in advance!
the numbers are greater than the value in one cell and less than the value in
another cell. However when I try to reference specific cells as the criteria
in the formula I get a #DIV/0! error.
The formula reads: =AVERAGEIFS(B3:B15,B3:B15,">B18",B3:B15,"<B19")
IN this case B3:B15 are:
23
31
17
35
41
30
23
34
29
26
29
20
34
And B18 is 22 and B19 is 35
If I replace B18 with 22 and B19 with 35 in the forumla,
i.e. =AVERAGEIFS(B3:B15,B3:B15,">22",B3:B15,"<35")
it calculates correctly with no error.
Why can't a refence those cells as the criteria??? Thanks in advance!