Ask Your Question

libreaskask's profile - activity

2017-11-02 00:31:22 +0100 received badge  Popular Question (source)
2017-11-02 00:31:22 +0100 received badge  Notable Question (source)
2017-11-02 00:31:22 +0100 received badge  Famous Question (source)
2016-07-18 18:38:28 +0100 asked a question Calculate standard deviation of specific rows

Hi!

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.