standard deviation if

[Noz2k]

I have a few Averageifs statement to ascertain the mean when certain criteria is met, however would like to do the same for those values where the criteria is met to calculate the standard deviation.

Here is an example of the formula used to calculate the average

=AVERAGEIF(Sheet1!$Q$2:$Q$2083,"="&ByMVIR!$B6,Sheet1!$R$2:$R$2083)

 

[VoG]

Try

=STDEV(IF(Sheet1!$Q$2:$Q$2083=ByMVIR!$B6,Sheet1!$R$2:$R$2083))

confirmed with CTRL + Shift + Enter, not just Enter.

 

[Noz2k]

Worked a treat, thanks