# Excel : Standard Deviation

Zeltine 16:20 24 May 07
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 07

but what conditions?

Zeltine 17:35 24 May 07

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 07

=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 07

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.

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…