I am looking for a formula similar to sumif that can add values based on a previous cell's value being yes. I'm working on an order form where there are multiple columns and you can select yes for all options you are interested in. I want a formula to then calculate the total price by adding the price listed to next to each cell with a yes in it. Is this possible?

Example:

Person Bananas $ Apples Carrots Spinach
ABC Yes $2.50 Yes $1 Total would be $3.50