Applying a multiplier based on data validation selection

not sure what answer you want, let's say you have yes, maybe, maybe and no, what answer do you expect, a sum for the value of eacy? this will get you that...
=SUMPRODUCT((D3:D6={"maybe","yes"})*({0.5,1}))
that will return 2, .5 for both maybes and 1 for the yes.
now if you want a weighted average, maybe this instead...
=SUMPRODUCT((D3:D6={"maybe","yes"})*({0.5,1}))/SUM(COUNTIF(D3:D6,{"yes","maybe"}))
that will return .667 for the same selected answers above which is the addition of the two .5s and the 1 divided by 3 for the total.
didn't see the point in adding in the no answer since it equals 0 and therefore no weight.
if however you want the weighted average to include no answers then...
=SUMPRODUCT((D3:D6={"maybe","yes"})*({0.5,1}))/COUNTA(D3:D6)

BTW, the no won't change the output... =SUMPRODUCT((D3:D6={"no","maybe","yes"})*({0,0.5,1}))

You don’t have 5 question ones, you only showed one question one with three possible answers. Unless you are saying question one is worth 5 points and question two 10 points and question three- 5 points and question 4 - 29?

If so I’m on an iPad now so unless someone else comes along I’ll revisit it later.

so let's try this for now... =SUMPRODUCT((D3:D6={"no","maybe","yes"})*({0,0.5,1})*(B3:B6))
that seems to return what you are looking for.