STDEV.P - ignore cells with value 0

You will need to use this array formula:

=STDEV.P(IF(J4:M4>0,J4:M4))

Being an array formula it must be confirmed with Ctrl-Shift-Enter instead of Enter when exiting edit mode. If done correctly then excel will put {} around the formula.

enter image description here


Wrap the formulas in the input cells as such:

=if( OriginalFormula <= 0, "", OriginalFormula )

The STDEV (and several other)functions ignore any non-numeric value.

Tags:

Microsoft Excel

Related

Convert three letter month abbreviation to number? Cannot dismiss certain reminders in lightning/thunderbird Why is the Ubuntu VM screen corrupted on my HiDpi laptop? Windows 10 failed to install English (GB) typing, English (GB) optical character recognition ...... error code: 0x800F0908 What kind of special character is this: ? In 802.11n, is it possible to have MIMO on single antenna? PowerShell: How do I append a prefix to all files in a directory? Chrome's modal dialog box stuck off screen. How to move it back permanently? How to have the same text in multiple places be changed or refactored at once? disable MTP udev rules for specific device so it can be mount as a USB Mass Storage device Is it possible to have Windows 10's interface in language X but have default keyboard-layout to language Y? How to always enable numlock by default on Windows 10?

Recent Posts