AVERAGEIF doesnt seem to work for me

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

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

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