I have created two columns, one that has a criteria and another that has the
criterias cost. The criteria has about 200 rows of data that is all mixed up.
Can I create a drop down list so I can chose one criteria and this then shows
the total cost for all of that criteria added up.

The column for the criteria has about 20 parts all with a costing, but i
need to abe able to select one criteria and be able to add up all of its
costing, taken from many cells in one column. How can I do this?