Appreciate some help. I have a drop down selection in Column A for conference registration: "1 = Required" "2 = Should go" and "3 - Nice to have." Column B has a dollar amount for the conference. It's a long list, and sorting is a pain since we can change the classifications. Column B is good for the cumulative total. I'd like to have three breakdown columns for Required, Should Go, Nice to Have, that I can then total separately. So In essence, if column a says "1 = Required," then populate the value in Column B into Column C.

Can you help?