How do I run the STDEV function with multiple criteria?

  • Thread starter Thread starter JLMcCracken
  • Start date Start date
J

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
 
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]...
 
Back
Top