| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Symbols in Drop Down Lists | Excel Worksheet Functions | |||
| Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
| multiple drop down lists | Excel Discussion (Misc queries) | |||
| Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) | |||
| How do I change the appearance of my drop down lists? | Excel Worksheet Functions | |||
Linear Mode
