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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks