Sum based on multiple Criteria

[A11 Mighty]

Hello -
I have an interesting request that I was hoping I can get some assistance with.
I would like to create this pricing / Options model that can use "X" as a way to select the options/ product and add the costs based on the selected items.

Request 1

1. A user can select one from either product 1 or 2 using an "X". User can NOT select both.
2. A user can select Option 1 or 2 or both using an "X".
3. When an "X" is entered in the selected field have a way to sum the corresponding costs for the items selected.

Request 2

1. A user can apply a discount to the total price up to 15%. When an "X" is entered in the field corresponding to discount.

I am attaching the excel with a sample and desired output.

Any help is much appreciated!

Thank you

 

[bindassladka]

would love to help, but didn't understand the request. Could you please eloborate it further.

 

[A11 Mighty]

@bindassladka Certainly and appreciate the assistance.
For request 1
Example:
When the user enter an "X" in the cell corresponding to the options he would like to sum the pricing for. This will pull the price associated with what's selected and add them together.

In the example below the user Picked
=Product 1/2 +Option 1/2 + Option 2/2
= $1 + $1 + $1
= $3



NOTE:
The user can only pick between Product 1 or Product 2. They can't select both at the same time.
When the user enter an "X" in Option 1 as an example, it will lookup that selected option and pull price from column AA.

Please let me know if this makes sense or if you need additional clarification.

Thank you

 

[vletm]

A11 Mighty​

Have You verified row #8's P-column writing?
... based cell D12 notes (User can pick either Option 1 or 2 or both = gotta be picked one ).
Q-column shows Total $$
R-column shown Notes, which user has skipped.