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

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