I have a worksheet with over 1000 entries. One column has a drop down menu
with a choice of 6 inputs, another column has different numbers on each row.
I would like to find a formula that will add the numbers for each of the 6
inputs.

If that makes sense!