Dear ladies and gents, please help me figure out how to build a formula for a
column of 150 cells, where I need to obtain the average excluding the cells
containing zeros and numbers above 39000. I tried
=AVERAGE(if(L3:L150<390000, L3:L150,false)) and it gives me a number I am
not sure is right. Thank you so much.