If statement with standard deviation not giving correct value

Originally Posted by excel12121

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.

Empty cells in the range 'All Subject Data'!$J$2:$J$5220 will be evaluated as 0.

See post #4 for a method to account for those.