I have 5 plus variables. See below for types of criteria. If the criteria
meet certain conditions then it needs to sum all the appropriate values for
that case:

One criteria could be risk, another size and a third time.

Col A Col B Col C
Risk Value Weight
Row 1 1 1 0.9
Row 2 2 0
Row 3 3 0
Row 4 4 0

Col D Col E Col F
Time Value Weight
Row 1 Short 0
Row 2 Med 0.9 0.95
Row 3 Long 0

Col G Col H Col I
Size Value Weight
Row 1 Small 1.2 0.8
Row 2 Med 0
Row 3 Large 0

A B C
Case A: Risk Time Size
Row5 1 Short Small

So in this case it would get 1*(0.9/(0.9+0.8)) for risk and
1.2*(0.8/(0.9+0.8)) for size = number. What is the most efficient way to do
this?

Thank you