Results 1 to 3 of 3

Thread: Nested formulas (Sumif & vlookup)

  1. #1

    Post Nested formulas (Sumif & vlookup)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Please help with the following request.

    I want to insert a formula in the green areas to automate the calculation. the data is coming from the table below.
    Sum if Sum if Sum
    Code1 Code 2 Positive Code 2 Negative Code 3
    WS3A 13.00 (5.00) 2200
    WSJM 7.00 (12.00) 1800
    WSIE 0 (9.00) 600
    WS6A 26.00 (11.00) 3200
    Total 46.00 (37.00) 7,800.00
    Data:
    Code 1 Code 2 Code 3
    WS3A 5.00 100
    WS6A 14.00 200
    WSJM (4.00) 300
    WSJM (8.00) 400
    WS3A 8.00 500
    WSIE (9.00) 600
    WS3A (4.00) 700
    WS6A (9.00) 800
    WS3A (1.00) 900
    WS6A 12.00 1000
    WSJM 7.00 1100
    WS6A (2.00) 1200
    9.00 7,800.00
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Try

    B6:

    =SUMIFS(Code_2,Code_2,">0",$G$6:$G$17,$A6)

    in C6:

    =SUMIFS(Code_2,Code_2,"<0",$G$6:$G$17,$A6)

    in D6:

    =SUMIFS($I$6:$I$17,$G$6:$G$17,$A6)

    each copied down.


  3. #3
    Perfect!

    Thanks for your prompt help.

Posting Permissions

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