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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>