Help with STDEV

[clueless_bookworm]

Hello, I have a range of data containing values of 0, 1 and 2. There are a few N/A'd cells in this range as well. I need to calculate the standard deviation of the range.
I started with =STDEV.S(G5:G43) and i'm getting a #DIV0 error. Is it because of the N/As? help!

 

[DanteAmor]

Hi @clueless_bookworm.
Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

I don't have a problem, but try the array formula I put in cell G46

Dante Amor
	A					F	G	H
1
2
3
4
5							1
6							0
7							0
8							N/A
9							0
10							1
11							0
12							0
13							N/A
14							1
15							0
16							0
17							0
18							0
19							0
20							0
21							0
22							0
23							N/A
24							0
25							0
26							0
27							0
28							0
29							0
30							0
31							0
32							0
33							0
34							0
35							0
36							0
37							0
38							0
39							0
40							0
41							0
42							0
43							0
44
45							0.280305955
46							0.280305955
Import (2)

Cell Formulas
Range	Formula
G45	G45	=STDEV.S(G5:G43)
G46	G46	=STDEV.S(IF(G5:G43<>"N/A",G5:G43))
Press CTRL+SHIFT+ENTER to enter array formulas.

--------------
I hope it helps you.
Respectfully
Dante Amor
--------------