# Mutiple Conditional somproduct problem

1. ## 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. ## 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. ## 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.

4. ## Re: Mutiple Conditional somproduct problem

Thanx, here is the file

5. ## Re: Mutiple Conditional somproduct problem

Try:

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

With file...

7. ## Re: Mutiple Conditional somproduct problem

Hi Glenn,

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

Regards
Ruud

8. ## 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.

##### Users Browsing this Thread

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

#### 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