+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : stdev if?

  1. #1
    Forum Contributor
    Join Date
    06-28-2010
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    101

    stdev if?

    i have a list of numbers in one column and an answer (yes/no) in the next colomn
    i want to check the standard deviation only if they answered yes
    i know there isn't an stdevif function similar to averageif in excel 2007 but could anyone recommend a clever way in solving my problem?
    thanks

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2007+2010+2013
    Posts
    14,227

    Re: stdev if?

    You can use an array formula like

    =STDEV(IF(B2:B100="Y",A2:A100))

    confirmed with CTRL+SHIFT+ENTER
    Audere est facere

  3. #3
    Forum Contributor
    Join Date
    06-28-2010
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    101

    Re: stdev if?

    thanks!!!
    i did that but it didn't work until i ctrl+shift+entered

+ 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