Drop Down Lists
 

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?

Yes, just create a formula that picks up the selected value and sums from
the two columns

=SUMIF(H1:H100,A1,I1:I100)

--
HTH

Bob Phillips

"DruryFire" wrote in message
...
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?