If statement with standard deviation not giving correct value

Yes sir, entered as an array. I even checked it both if it includes blanks as zeros (there are a few but not many) and it still was way way off the actual stdev.

Originally Posted by Tony Valko

Your formula is syntactically correct.

Did you enter it as an array formula?

Array formulas are entered differently than a regular formula.
After you type in a regular formula you hit the ENTER key.
With an array formula you *must* use a combination of keys.
Those keys are the CTRL key, the SHIFT key and the ENTER key.
That is, hold down both the CTRL key and the SHIFT key then
hit the ENTER key.

When done properly Excel will enclose the formula in squiggly
brackets { }. You can't just type these brackets in, you
*must* use the key combo to produce them. Also, anytime
you edit an array formula it *must* be re-entered as an
array using the key combo.