+ 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
    5

    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
    5

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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

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

    Re: Mutiple Conditional somproduct problem

    Thanx, here is the file
    Attached Files Attached Files

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Mutiple Conditional somproduct problem

    Try:

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




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    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
    5

    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 Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    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)

Similar Threads

  1. somproduct with condition containing reference
    By nielsb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-15-2018, 01:48 PM
  2. [SOLVED] SOMPRODUCT from different columns multiplied by VAT factor
    By rvfotopro in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2017, 10:08 AM
  3. Conditional formating, mutiple variables, mutiple sheets
    By Adam_D in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2012, 06:47 AM
  4. Repost: problem with mutiple summing....
    By Shane Moore in forum Excel General
    Replies: 4
    Last Post: 03-01-2012, 03:07 AM
  5. Somproduct
    By Selo in forum Excel General
    Replies: 4
    Last Post: 03-05-2008, 08:13 PM
  6. [solved] somproduct
    By Jaydubs in forum Excel General
    Replies: 2
    Last Post: 07-19-2006, 05:00 AM
  7. mutiple conditional formating
    By Roz in forum Excel General
    Replies: 7
    Last Post: 12-19-2005, 04:09 PM

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