Home

Stdev of a group of numbers continain #value!

%3CLINGO-SUB%20id%3D%22lingo-sub-1191784%22%20slang%3D%22en-US%22%3EStdev%20of%20a%20group%20of%20numbers%20continain%20%23value!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1191784%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20calculate%20SD%20for%20a%20bunch%20of%20numbers.%26nbsp%3B%20One%20number%20is%20%23Value!.%26nbsp%3B%20I%20tried%20it%20using%26nbsp%3B%3DAVERAGE(IF(ISERROR(E32%3AE37)%2C%22%22%2CE32%3AE37))%20but%20substituting%20StDev%20fir%20Average%2C%20but%20it%20didn't%20work.%26nbsp%3B%20Any%20solutions%3F%3CBR%20%2F%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1191784%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1192340%22%20slang%3D%22en-US%22%3ERe%3A%20Stdev%20of%20a%20group%20of%20numbers%20continain%20%23value!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1192340%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F490747%22%20target%3D%22_blank%22%3E%40Elbarcolutra%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formula%20must%20work%20fine.%26nbsp%3B%20You%20have%20to%20introduce%20the%20formula%20with%20the%20combination%20Ctrl%20%2B%20Shift%20%2B%20Enter%20(CSE)%20instead%20of%20just%20Enter%20(if%20you%20have%20Excel%202016%20or%20older%20version%20of%20Excel).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20this%20formula%20too%20(CSE)%20%3A%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23993366%22%3E%3DSTDEV(IFERROR(E2%3AE27%2C%22%22))%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBlessings!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

 

1 Reply
Highlighted

@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!