Eliminating a cell with 0 value from Median

[Nunzio]

I want to use a range in MEDIAN but want to exclude cells with a 0 value.

MEDIAN(K2:K27)

[NBVC]

Try:

=MEDIAN(IF(K2:K27<>0,K2:K27))

confirmed with CTRL+SHIFT+ENTER not just ENTER.

[Nunzio]

I am getting a #VALUE

[NBVC]

Did you figure it out. ... I see you marked it Solved after your last post?

[Nunzio]

Yes, Thanks

MEDIAN(IF(ISERROR(K2:K27<>0),K2:K27))

[NBVC]

I am not sure how that fixed your problem?

Do you have errors in your K2:K27 range...

I don't get that error unless I have that error within the range already.