+ Reply to Thread
Results 1 to 8 of 8

Mutiple Conditional somproduct problem

  1. #1
    Registered User
    Join Date
    09-04-2018
    Location
    Tilburg, Holland
    MS-Off Ver
    2016
    Posts
    4

    Mutiple Conditional somproduct problem

    Hi,

    I have some troubles with finding the right formula in Google Sheets for somthing I want to do.
    I think that it is a mix between two function somproduct and sum.if but I can't get the right formula.
    I Added a excel sheet with an example of what I want to do.

    Could anybody help me with this?
    Thanx

    Regards
    Ruud

    Hmm? Seems that I can't add an attachment.
    I have a link to my public folder in Dropbox. I'm not allowed to add it here?!!

    Regards
    Ruud Verhoosel

  2. #2
    Registered User
    Join Date
    09-04-2018
    Location
    Tilburg, Holland
    MS-Off Ver
    2016
    Posts
    4

    Re: Mutiple Conditional somproduct problem

    OK a replay with the link is also not allowed. Then a copy paste solution:

    City Contractor Residents Agree Yes No Energy EXCL. 6% Tax Energy EXCL. 21% Tax Architectual EXCL. 6% Tax Architectual EXCL. 21% Tax More / Less EXCL. 6% More / Less EXCL. 21%
    RIJEN Caspar Yes € 3.419,53 € 3.301,94 € 176,00 € 2.354,99 € 50,00 € 205,50
    RIJEN Caspar No € 3.641,50 € 3.483,56 € 181,76 € 2.435,79 € 550,00 € 205,50
    RIJEN Caspar
    RIJEN Caspar Yes € 2.569,44 € 2.744,34 € 88,00 € 1.670,14 € 20,00 € 205,50
    RIJEN Caspar No € 3.641,50 € 3.483,56 € 181,76 € 2.435,79 € 25,00 € 205,50
    RIJEN Coen
    RIJEN Coen Yes € 3.454,11 € 3.330,24 € 176,00 € 2.564,55 € 100,00 € 205,50
    RIJEN Coen
    RIJEN Coen Yes € 3.419,53 € 3.301,94 € 193,51 € 2.564,55 € 50,00 € 205,50
    RIJEN Caspar Yes € 3.419,53 € 3.301,94 € 193,51 € 2.254,27 € 75,00 € 205,50

    If Resisident = Yes and contractor = a15 the result has to be 26255,13

    caspar

    When A15 = is changed in Coen the result has to be 19565,43
    When nothing is filled in the result shoul be empty

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,115

    Re: Mutiple Conditional somproduct problem

    You can upload a file here, but not post links until you have at least 10 posts (to help prevent spam)
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

  4. #4
    Registered User
    Join Date
    09-04-2018
    Location
    Tilburg, Holland
    MS-Off Ver
    2016
    Posts
    4

    Re: Mutiple Conditional somproduct problem

    Thanx, here is the file
    Attached Files Attached Files

  5. #5
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    18,600

    Re: Mutiple Conditional somproduct problem

    Try:

    =SUMPRODUCT(($B$2:$B$11=$A$15)*($C$2:$C$11="Yes")*$D$2:$I$11)
    Glenn



  6. #6
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    18,600

    Re: Mutiple Conditional somproduct problem

    With file...
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    09-04-2018
    Location
    Tilburg, Holland
    MS-Off Ver
    2016
    Posts
    4

    Re: Mutiple Conditional somproduct problem

    Hi Glenn,

    This works perfectly, great!
    Thanks a lot, now I can go to work

    Regards
    Ruud

  8. #8
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    18,600

    Re: Mutiple Conditional somproduct problem

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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