Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Chicago
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sumif with 2 criteria (XP)

    Please see attachment.
    I would like to be able to sum the obligated amounts (in column I) if the fiscal control point (in column [img]/forums/images/smilies/cool.gif[/img] =080 and if the date (in column L) is <1/1/05.
    Any help is greatly appreciated - thanks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: sumif with 2 criteria (XP)

    How about:
    <pre>=SUMPRODUCT((B2:B50="080")*(L2:L50<DATE(2005, 1,1)),I2:I50)</pre>


    Steve

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sumif with 2 criteria (XP)

    The array formula below should do what you asked. This is an array formula, so hold down Ctrl and Shift when you press Enter to confirm the formula.

    <pre>=SUM((B2:B50="080")*(L2:L50<DATE(2005,1,1))*I 2:I50)
    </pre>

    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Chicago
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sumif with 2 criteria (XP)

    Perfect! You guys are the best - thanks.

Posting Permissions

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