Is there a way to apply a formula to a set of data that is chosen based on a data validation drop down list. In this case I have a list of different criteria and based on the selection made various columns will be included in a sum formula while other values are excluded. Depending on the row for which the selection is made the formula would need to add the columns in that specific row. I almost feel like there would be some combination of indirect, vlookup and named ranges involved. I would use an IF statement but there are too many different combinations of formulas and I may need to add, subtract or edit the various formulas on a regular basis. I can provide more detail if needed.

Thanks!