Altering my formula for stdev

Hello,

I have this formula, which works for averaging the values that I want:

Please Login or Register  to view this content.

But now that I have the average of the numbers, I would like the stdev. How can I alter the averageif to be a stdev (if)?

Thanks

Originally Posted by bjcowen9000

I have this formula [...]:
=AVERAGEIF($A$1:$A$5913,"="&H2,$B$1:$B$5913)
But now that I have the average of the numbers, I would like the stdev.

{ =STDEV(IF($A$1:$A$5913=H2,$B$1:$B$5913)) }

Formulas displayed with curly brackets {...} are array-entered, to wit: type the formulas without the curly brackets, then press ctrl+shift+Enter instead of just Enter. Excel displays the curly brackets in the Formula Bar to indicate that the formula is array-entered.

Use STDEVP instead of STDEV if the values in B1:B5913 represent all of your data, not a sampling, and you are not trying to estimate the std dev of a larger set of data.