+ Reply to Thread
Results 1 to 3 of 3

How to take standard deviation of only positive cells

  1. #1
    Registered User
    Join Date
    10-25-2010
    Location
    Chicago Illinois
    MS-Off Ver
    Excel 2007
    Posts
    7

    How to take standard deviation of only positive cells

    Hello all...this is my first post.

    I have excel 2007 and am trying to find the function for calculating the standard deviation for only the positive numbers in a table of data...

    Any help on this is much appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    10-17-2010
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013, 2016, 2019, 365
    Posts
    294

    Re: How to take standard deviation of only positive cells

    Something I learned last week from a forum guru...
    Suppose A1:A6 is the data you want, but only including the positives. Put an IF() in your function like so,
    =STDEV(IF(A1:A6>0,A1:A6))
    and make sure you hit Ctrl-Shift-Enter to turn it into an array formula. {Curly brackets appear round the formula}
    As if by magic....

  3. #3
    Registered User
    Join Date
    10-25-2010
    Location
    Chicago Illinois
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How to take standard deviation of only positive cells

    awesome...thanks for your help....the ctrl+shft+entr was a big help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1