Conditional Pricing Matrix

Hello excel geniuses! This is probably a simple solution but I am puzzled. I am trying to create a pricing matrix that looks at values in a row (x vs. any other value), and then based on whether an x is entered, sums a price but without putting the price in the cell. In other words, one column is a list of features (power windows, ABS, convertible, etc), the next row contains the prices for those options, and the next row is simply to mark yes or no using an x to indicate whether the option has been selected. At the bottom of the row containing the yes/no selections populated with x or nothing, a total price would be rendered. I started with the following:

=IF(D5="x",B5,0)+IF(D6="x",B6,0)...etc., but that seems clunky particularly given a very long list. Any ideas as to a simper way of doing this?

Have you tried the SUMIF formula?

e.g. =SUMIF(B1:B20,"x",A1:B20)

Worked perfectly, thanks for your help. I have a follow on question that I'm hoping you or someone else may be able to help with. Each of the options that can be selected has its own 1 or 2 letter designation in a separate column of the table (e.g., convertible = "CO", etc.). As part of this pricing matrix, I want to build a part number based on the letter designations for the options that have been selected. I'd like this part number to be aggregated into a single cell in the workbook. Any idea how to do this? Putting the option designations into separate cells based on the option selections is easy, but getting them to aggregate into the same cell is what I can't figure out. Thanks for any help anyone can provide!

Suggest posting a copy of the workbook together with an example of what you want the output to look like.