How do i calculate Standard Deviation on Negative Numbers Only

[daapower]

I have a spreadsheet with both positive and negative numbers. How would
I calculate the standard deviation for just the negative numbers
without selecting them manually.

 

[rbrychckn]

Using an array formula (once entered, hit cntrl+shift+Enter in th
formula field), use the following formula where A1:A9 is you
range/array of positive and negative numbers:

=STDEV(IF(A1:A9<0,A1:A9))

(which will look like {=STDEV(IF(A1:A9<0,A1:A9))} once entered a
mentioned above)

To

 

[daapower]

thanks, works great

 

[vvc]

hello everyone,

i've a series of positive and negative values, i would like to calculate standard deviation for all of them. How can i calculate the standard deviation for both positive and negative values?

thanks in advance.