| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find for non zero values in a column Median,Mode,STDEV
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mean, median, mode, standard diviation | Charts and Charting in Excel | |||
| calculating median and mode | Excel Worksheet Functions | |||
| Find the median 3 values | Excel Discussion (Misc queries) | |||
| STDEV function on selected values | Excel Worksheet Functions | |||
| MEDIAN, STDEV of a range IF another range = specific value | Excel Worksheet Functions | |||
Threaded Mode
