Ask Your Question

AVERAGEIF doesnt seem to work for me [closed]

asked 2018-06-08 23:51:43 +0200

Levano gravatar image

I want to search for values in a set that are simultaneously greater than 1 and less than 5, currently, I have:


From looking at the wiki it seems this should work but it doesn't

Any help is greatly appreciated Thanks in advance

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-16 12:26:23.251718


The question could be improved by giving a link to the wiki page you looked at.

Jim K gravatar imageJim K ( 2018-06-12 07:32:49 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-06-09 01:49:15 +0200

m.a.riosv gravatar image

Using =AVERAGEIFS(B65:S65,">1",B65:S65,"<5") so several conditions are possible.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-06-08 23:51:43 +0200

Seen: 87 times

Last updated: Jun 09 '18