Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
STDEV function on selected values
Hi all,
I am wondering one groovy function that 1. Selects values according to my criteria, such as more than 0 (zero) AND less than 5000, and 2. Take standard deviation of the selected values. I know a function like "=SUMPRODUCT((C4:C340)*(C4:C34<5000))" counts the values that are more than 0 and less than 5000 in the range of Cell C4:C34, but not appropriate for my purpose. So, how can I do that bit and enclose it in =STDEV() function? Thanks! Tetsuya Oguma, Singapore |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
STDEV function on selected values
=STDEV(IF((C4:C340)*(C4:C34<5000),C4:C34))
array entered (Ctrl-Shift-Enter) Jerry "Tetsuya Oguma" wrote: Hi all, I am wondering one groovy function that 1. Selects values according to my criteria, such as more than 0 (zero) AND less than 5000, and 2. Take standard deviation of the selected values. I know a function like "=SUMPRODUCT((C4:C340)*(C4:C34<5000))" counts the values that are more than 0 and less than 5000 in the range of Cell C4:C34, but not appropriate for my purpose. So, how can I do that bit and enclose it in =STDEV() function? Thanks! Tetsuya Oguma, Singapore |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
STDEV function in VB scritp for excel | Excel Worksheet Functions | |||
How do I run the STDEV function with multiple criteria? | Excel Worksheet Functions | |||
Stdev function error! | Excel Discussion (Misc queries) | |||
Rounding error in Stdev function result. | Excel Worksheet Functions | |||
Averaging selected values | Excel Worksheet Functions |