Drop Down Lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top