Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excluding "0" in standard deviations
Hi,
In calculation standard deviations I am using the formular =SUBTOTAL(7;B2:B100) which appears to work nicely when filtering. However, it also includes cells with "0". Can anyone tell me, how the formular needs to be changed so only numbers "0" is included? Many thanks in advance, Niclas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I alphabetize data excluding words like "a" and "the"? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Count Common Denominator, but excluding "#value!" | Excel Worksheet Functions | |||
Standard font in a "New Microsoft Excel Worksheet.xls" wont change | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |