Ask Your Question
0

Reference cell in Averageif criteria not working

asked 2017-06-10 15:29:14 +0200

updated 2017-06-10 15:39:07 +0200

I used the formula =AVERAGEIF('m-1'.E:E,"&B6&",'m-1'.I:I)

range e:e in the sheet m-1 has multiple values , out of which I check with the value i enter in b6. When I enter the actual string in the criteria instead of referencing then the function works fine but when I reference it to b6 it shows me a div/0 error.

String matches are exact, I get the same issue even if I use. * in criteria

Please help me out on how to solve it

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-06-10 20:25:49 +0200

updated 2017-06-10 20:26:00 +0200

What do you mean by "&B6&"?

I suppose that you want something like this:

=AVERAGEIF('m-1'.E:E,B6,'m-1'.I:I)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-06-10 15:29:14 +0200

Seen: 29 times

Last updated: Jun 10 '17