Median Price

[elsmith9035768]

I need the median price of cells G6, G7, G9, and G12, but excluding any cells that have a zero. I keep getting a message, "You have entered too many arguments for this function". I am assuming the message is due to the cells not being consecutive going down the column. I am using a comma to separate each cell in the formula. See example. Thanks.

 

[Nebu]

Hi:

May an array formula?

=MEDIAN(IF(G6:G12<>0,G6:G12))

Confirm Using Control+Shift+Enter Keys.

Thanks

 

[GraH - Guido]

seems duplicate post with https://chandoo.org/forum/threads/c...t-range-and-excluding-zero.40467/#post-241922
Please continue in the original one elsmith9035768.

 

[elsmith9035768]

I didn't think the formula from the last post would work as this is another worksheet and there are non-numeric filled fields in G8-G11 while all the fields calculated in the last formula were numeric.

I just realized there I a problem, sometimes 12G will be the same figure as 9G. In those instances, I do no want 12G included in the median calculation. How do I alter the formula to not count 12G in the instances that it has the same figure as 9G but included when there is another figure other than zero?