clueless_bookworm
New Member
- Joined
- Apr 27, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help with STDEV
- Thread starter clueless_bookworm
- Start date
DanteAmor
Well-known Member
- Joined
- Dec 3, 2018
- Messages
- 17,837
- Office Version
- 2019
- Platform
- Windows
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
--------------
I hope it helps you.
Respectfully
Dante Amor
--------------
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
--------------
Upvote
0
