Calculation of Standard deviation with a criteria

Sibali_B

I need to calculate standard deviation for "Paul" only in Smartsheet

Column 1 Column 2

Paul 40

Alex 60

Paul 35

Dorothy 55

Simon 60

Paul 50

Paul Newcome

There are a few different Standard Dev functions (link below) to take your pick from, but regardless of which you choose, you are going to want to incorporate a COLLECT function.

=STDEVA(COLLECT([Column 2]:[Column 2], [Column 1]:[Column 1], @cell = "Paul"))

Paul Newcome

There are a few different Standard Dev functions (link below) to take your pick from, but regardless of which you choose, you are going to want to incorporate a COLLECT function.

=STDEVA(COLLECT([Column 2]:[Column 2], [Column 1]:[Column 1], @cell = "Paul"))