How do I run the STDEV function with multiple criteria?

[JLMcCracken]

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

 

[Biff]

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),B1:B10))

Biff

"JLMcCracken" <[email protected]>
wrote in message
news:[email protected]...