Ask Your Question

Calculate standard deviation of specific rows

asked 2016-07-18 18:38:28 +0200

libreaskask gravatar image


I have a table formatted similar to this:

v   1
v   4
v   2
s   1
s   1
v   8
s   2

How can I calculate the standard deviation of rows that have an "s" in the first column? I tried: =STDEV(IF(A1:A10="s",B1:B10)) and all variations that I could think of but it does not work.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-07-18 19:13:47 +0200

mark_t gravatar image

You need to enter as an array function using ctrl-shift-enter or check the array box in the function wizard.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-07-18 18:38:28 +0200

Seen: 2,111 times

Last updated: Jul 18 '16