Results 1 to 3 of 3

Excel 2003 STDEV and SUMIF Formulas with Multiple Criteria

Threaded View

xet Excel 2003 STDEV and SUMIF... 04-24-2012, 01:35 AM
xet Re: Excel 2003 STDEV and... 04-24-2012, 10:21 AM
daddylonglegs Re: Excel 2003 STDEV and... 04-24-2012, 10:36 AM
  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Excel 2003 STDEV and SUMIF Formulas with Multiple Criteria

    Hi,

    I am trying to get the two formulas to work below. Basically for the first one I am trying to take the stdev of all the values in column Q that have the data in column J values listed are = "1", as well as the value in O being >19 as well as <39. If J=1, and O>19 as well as O<39, I would like it to take the stdev of all the values that fit the criteria in row Q.

    The second one is very similar, except I want to sum the values if they meet the criteria.

    =STDEV(IF((J2:J6357="1")+(O2:O6357>="19")+(O2:O6357<="39"),Q2:Q6357))
    =SUMIF(J2:J6357,(J2:J6357="1")+(O2:O6357>="19")+(O2:O6357<="39"),Q2:Q6357))
    Thank you so much for your help
    Last edited by xet; 04-24-2012 at 01:47 AM.

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