| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to compute StDev of only nonzero entries in a range?
I know that one can compute the average of nonzero entries in column C by
using the formula C378=SUM(C387:C566)/(COUNTIF(C387:C566,"0")). However, how can one compute the standard deviation of nonzero entries in the range C387:c566? Thank you for any help that you may be able to give. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge, update, and add only new entries into a list from other she | Excel Worksheet Functions | |||
| How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
| GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS | Excel Worksheet Functions | |||
| multiple entries | Excel Worksheet Functions | |||
Threaded Mode
