Standard Deviation With If Statement

[larryg003]

Hi Fellas,

Quick Question:

I have two columns with the following data set:
Column A Column B Column C
0 11.5 20
0 13.5 34
0 12.2 114
1 14.0 9
1 7 4
1 12 3
0 2 2
0 3 99
0 9.6 32
1 2.3 1

I want to build an excel function that I can drag over to the right column by column to calculate the standard deviation of numbers that only have a 1 in the first column. So for example, the output for Column B would be: standard deviation of (14.0, 7, 12, 2.3); The output for Column C would be standard deviation of (9, 4, 3, 1)

Thanks!

Larry

[Pepe Le Mokko]

If you have a "quick question", you probably need a "quick" answer?
Then read the yellow banner..

[MarvinP]

Hi Larry,

Something like:

Please Login or Register  to view this content.

See the attached for my test.
StDev using If not zero.xlsx

[larryg003]

Thanks Pepe. Please find attached folks for

[MarvinP]

In B13 put this:

Please Login or Register  to view this content.

and pull to the right.

Similar to my workbook but now I see where you want the answer.