Excel : Standard Deviation

  Zeltine 16:20 24 May 2007
Locked

Any help would be appreciated, so thanks in advance!
Excel 2003, Need to calculate Standard deviation across a range of cells, but only on cells that meet a certain criteria.....

Thanks

  VoG II 16:24 24 May 2007

=STDEV(Your Range)

but what conditions?

  Zeltine 17:35 24 May 2007

For instance
a1=40
b1=43
c1=90
d1=33
e1=50

I would need excel to check each cell for criteria of 40 or above and then only using the cells which fit the criteria use these to calculate Standard devaition across those cells, I will be using STADEVPA.... thanks once again

  VoG II 18:22 24 May 2007

=STDEV(IF(A1:E1>=40,A1:E1))

which is an array formula and must be confirmed with CTRL + Shift + Enter, not just Enter. If entered correctly the formula should be displayed in the formula bar surrounded by curly braces {}.

  Zeltine 08:06 25 May 2007

Thank you VoG
This has helped no end, I need to look at array formulas more......
Its Friday, so have a good weekend

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

This is what design agencies will look like in 2032

How to update iOS on iPhone or iPad

WhatsApp : comment lire vos messages sans que l’expéditeur le sache