I had a question answered yesterday and I am grateful for it.

I have another, I need to know ho to get excel to calulate +1 and -1 stdev for a list of values and then sum the oultliers! I have tried doing it in a formula that I thought might work, but I keep getting 0 as the answer and I know this is incorrect.

example:

5, 6, 5, 6, 5, 6, 5, 19, 5, 1, 18,

I need the stdev of +1 and -1, which I know how to do in excel, but I cannot get it to sum the numbers ouliers in this example 19, 1, 18.
Sure I could do it manually but i need excel to do it as my calculations need to change as I add future values.
The sum, would go into a seperate cell that would be put into a seperate calculations.

please help!