Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I run the STDEV function with multiple criteria?
I need to find the standard deviation of the Males of different age groups and the STDEV function does not allow me to specify that only the males of a certain age group in my data should be included in the calculation. If anyone can tell me how to do this or what function to use it would be much appreciated. Thanks -- JLMcCracken ------------------------------------------------------------------------ JLMcCracken's Profile: http://www.excelforum.com/member.php...o&userid=37432 View this thread: http://www.excelforum.com/showthread...hreadid=571061 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I run the STDEV function with multiple criteria?
Hi!
Providing details helps! A1:A10 = M or F B1:B10 = age in years Find Stdev of M in the age group 25 to 50: Formula entered as an array using the key combination of CTRL,SHIFT,ENTER: =STDEV(IF((A1:A10="M")*(B1:B10=25)*(B1:B10<=50),B 1:B10)) Biff "JLMcCracken" wrote in message ... I need to find the standard deviation of the Males of different age groups and the STDEV function does not allow me to specify that only the males of a certain age group in my data should be included in the calculation. If anyone can tell me how to do this or what function to use it would be much appreciated. Thanks -- JLMcCracken ------------------------------------------------------------------------ JLMcCracken's Profile: http://www.excelforum.com/member.php...o&userid=37432 View this thread: http://www.excelforum.com/showthread...hreadid=571061 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Index function using multiple values in one cell | Excel Worksheet Functions | |||
Double and Multiple Lookup Using the MATCH Function | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
creating a function with multiple criteria | Excel Worksheet Functions |