Sum products

Hi,

I have this parts (#1) with that prices (#2) and I would like to sum them to get the regular price (#3) for different variations of the end product (#4).

2018-08-17 (2).jpg

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

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.

Good afternoon Tine123456

Don't delete this post. Click "Edit Post" beneath your first post, then follow Alan's instructions starting from "Click advanced...".

HTH

DominicB

Hi Tine123456

Have a look at the file below.
I have used "helper columns" (R - Y) to demonstrate what you need to do, you could amend these into one larger formula, but it would be tricky if you ever need to amend it.
You also have some Charging Cables that need incorporating into your cost table - see the error in cells R8 - R10.

HTH

DominicB

Hi DominicB

I had to correct the part of the VLOOKUP formula from $O$27 to $N$28 to resolve the #N/A issue (btw thank you for the formula). I also understand you made a 2nd formula of summing the price results from the "helper column", great stuff.

How can I add 399€ on top of my end result. Is this a sum in sum formula or something?

This is not a correct reference:

N$27$

This is correct:

$N$27

I correct it, thank you!

Hi Tine123456

Originally Posted by Tine123456

How can I add 399€ on top of my end result.

You mentioned this €399 value back in post 5, but I can't see it in your file anywhere? How do you get €399?

DominicB

With a very minor change in your pricing table, using no helpers, in I2, copied down:

=SUMPRODUCT(($M$6:$M$25=A$1:H$1)*($N$6:$N$25=A2:H2)*$O$6:$O$25)

This will return the cumulative value of the "add ons". To get an overall total:

=399+SUMPRODUCT(($M$6:$M$25=A$1:H$1)*($N$6:$N$25=A2:H2)*$O$6:$O$25)
or use a cell reference to pick up the pre-add-on price.

You may need ; instead of , as separators in these formulae.

Who are you talking to? Did you read post 12?

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.

It's always a good idea to specify who you are replying to... saves confusion!!

---

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.