Using standard deviation function in excel for a specific criteria

Question

I was wondering if there was a way to determine the standard deviation of numbers within a given range in a data set because I am currently working on a project. For instance, I want to figure out the standard deviation of the data points in my overall data that are larger than or equal to -0.5 but less than or equal to 0.5.

Answer 1

Use this:

=STDEV(IF((A1:A1000>=-0.5)*(A1:A1000<=0.5),A1:A1000))

Depending on one's version this may need to be array entered with Ctrl-Shift-Enter when exiting edit mode instead of Enter.