I am calcing a median value for a range, and the range includes zeros. I've
tried an array formula: ={if(A1:A40,median(A1:A4),0)} and another version of
the same: ={Median(if(A1:A40,A1:A4,0))}

Both of these formulas include the 0 values in the median calculation.

Does anyone know how I can remove them?

Thanks!