Hi,
I have a column Range J2:J300. I have seen from other posts the method of
getting the average(Mean) is
=SUM(J2:J300)/COUNTIF(J2:J300,"0")

I have tried for the STDEV
=STDEV(IF(J2:J300=0,"",J2:J300))
and get #VALUE!

The sheet will have various ranges imported (It is going to be used for
determining the statistics of a packaging machine) within the main range of
J2:J300
If other users are going to have this as a template is there a way to obtain
the Median, Mode, And StDEV of the column taking only positive numbers and
ignoring zero values?

Thank You
Bill