CODEWITHSUNDEEP
excelexcel-formulastandard-deviation
alpha189
alpha189

Reputation: 93

What's the equivalent averageifs for standard deviation?

I have asked aboutand already got answer about averageifs excel function here. However, I was also wondering if I can get standard deviation for the same data set in new column. Here is the screenshot of sample data:

Upvotes: 4

Views: 10585

Answers (1)

nbayly
nbayly

Reputation: 2167

You can use an array formula to first filter through your rows and then apply the standard deviation to the sample. Formula would look like this:

=STDEV.S(IF((IF(C:C="alpha",1,0)*IF(D:D="S14",1,0))=1,B:B,""))

Inputted using CTRL + SHIFT + ENTER. Cheers,

As provided by @ScottCraner in the comments the much improved formula:

=STDEV.S(IF((C:C="alpha")*(D:D="S14"),B:B))

Upvotes: 6

Related Questions