similar formula of averageifs() like for standard deviation

Colin Legg · #2 01-12-2012, 09:23 AM

Hi Sandy,

Excel doesn't currently have the equivalent of a STDEVIFS() function, so you would either have to use a helper column or an array formula to get the same effect.

For example, if you have these values in F4:G9

Code:

a  1
a  3
b  4
a  5
a  6

Then, this array formula (CTRL+SHIFT+ENTER) would give you the STDEV corresponding to "a"

Code:

=STDEV(IF(F4:F8="a",G4:G8))

This formula gives the same result as

Code:

=STDEV(G4,G5,G7,G8)

Does that help?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comment in Word similar to Excel	eradem	Word	3	10-01-2011 11:54 AM
How to set standard format for all	TDV	Word	0	07-02-2011 09:41 PM
How do you create a list similar to an itunes list?	hatemail13	Excel	1	08-06-2010 02:21 AM
deviation	RolandVet	Excel	0	04-18-2010 12:38 AM
[Office]How to create project timeline similar to this?	Coderedpl	Project	0	09-11-2009 01:23 PM