Results 1 to 5 of 5
  1. #1
    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: Excel (Office 2003)

    In Summary B2:
    =SUMIF(Outstanding!$D$4:$D$35,$A2,Outstanding!I$4: I$35)

    In Summary C2:
    =SUMIF(Outstanding!$D$4:$D$35,$A2,Outstanding!L$4: L$35)

    Copy c2 to D2:E2

    Copy/autofil B2:E2 to B3:E15

    Steve

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: Excel (Office 2003)

    Hans or someone will come up with a more elegant solution, but this one seemed to work for me:

    SUM(1*(A2=Outstanding!$D$4:$D$35)*(IF(Outstanding! $L$4:$L$35<>"",Outstanding!$L$4:$L$35,0)))

    An array formula (CTRL+Shift+Enter), and fill down

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: Excel (Office 2003)

    AH, yes, SUM ignores the "" and considers it like a 0.

  4. #4
    Lounger
    Join Date
    Jun 2007
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional sum (Excel 2003)

    Subject edited by HansV to be slightly more descriptive than "Excel"

    I need to find a way to perform the following calculation and have been unsuccessful to make one myself or find one already done
    Attached Files Attached Files

  5. #5
    Lounger
    Join Date
    Jun 2007
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel (Office 2003)

    Thank you both for responding so quickly ...... the groovy world of xxxif functions has been opened ......... i appreciate the push in the correct direction ......

Posting Permissions

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