AVERAGEIF doesnt seem to work for me

English
,
#1

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

=AVERAGEIF(B65:S65,“1<”">5")

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

Any help is greatly appreciated
Thanks in advance

#2

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

#3

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

https://help.libreoffice.org/Calc/AVERAGEIFS_function

#4

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.