#### BradReynolds

##### New Member

- Joined
- Aug 3, 2010

- Messages
- 3

I am looking for a couple of creative ways to achieve the following in excel:

On a spreadsheet I have a list of numbers that have been identified as the top five defect drivers. Also established are a top five list of typically occurring defects. The end result that I am trying to get to is a stacked bar chart that exhibits the top five part numbers and which of the top five defects affect those part numbers. In other words, I’d like to write a formula that will lookup the part number from a list and then count the defects from the established list of five and return a number. Hope this is making sense. I have attached an excel file (SUM MULTIPLE CONDITIONS.xls) that will hopefully illustrate my goal a little better if needed.

I’d prefer to stay away from VBA as much as possible and stick with formula options.

Thanks!

On a spreadsheet I have a list of numbers that have been identified as the top five defect drivers. Also established are a top five list of typically occurring defects. The end result that I am trying to get to is a stacked bar chart that exhibits the top five part numbers and which of the top five defects affect those part numbers. In other words, I’d like to write a formula that will lookup the part number from a list and then count the defects from the established list of five and return a number. Hope this is making sense. I have attached an excel file (SUM MULTIPLE CONDITIONS.xls) that will hopefully illustrate my goal a little better if needed.

I’d prefer to stay away from VBA as much as possible and stick with formula options.

Thanks!

Last edited: