I am trying to calculate SD for a bunch of numbers. One number is #Value!. I tried it using =AVERAGE(IF(ISERROR(E32:E37),"",E32:E37)) but substituting StDev fir Average, but it didn't work. Any solutions?Thanks
The formula must work fine. You have to introduce the formula with the combination Ctrl + Shift + Enter (CSE) instead of just Enter (if you have Excel 2016 or older version of Excel).
You can use this formula too (CSE) :