list results of a combination

I have 5 columns that I want to include in a combination. In the 1st, 3rd, 4th, and 5th columns, I only want 1 option to be chosen. In the 2nd column, I would like 3 items to be chosen. I need the corresponding numbers to be added up.
Example: (I've attached a spreadsheet)

(Hazard) Wildfire 25

(Disruption) Water 15
(Disruption) Food 7
(Disruption) Transporation 6

(Loss of Life) 10-19 20

(Property Loss )20-29% 30

(Duration) 10-69 20

The total of this combination is 123.

Is there VBA code that would list all the combinations possible as well as add up their totals?

Thanks in advance!
Amy

Thank you so much! This is exactly what I needed!