Stdev of a group of numbers continain #value!

[Elbarcolutra]

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

[#2]

@Elbarcolutra,

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) :

=STDEV(IFERROR(E2:E27,""))

Blessings!