Out of curiosity, if I wanted to do this with an IF(AND function with the ranges between 3 and 4 would it be like, =AVERAGE(IF(AND($A$1:$A$6>33,$A$1:$A$1:$A$6<4),$B$1:$B$6))) ?

Thank you in advance