Excel 2007 : Sum values for multiple answers

[martin_84]

Hi I have a survey I'm analyzing using multiple answers for each person how do I plot this into excel to get a bar that makes sense?

In advance thank you

[zbor]

Upload example workbook.

[martin_84]

Upload example workbook.

example of the values

[Haseeb Avarakkan]

Hello martin,

So how do you want to analyze this data? Just count the numbers separated in comma??? it would be helpful re-attach the file with your desired results 7 a little brief how did you arrive to those answers.

[martin_84]

well basically I want I bar that shows person 1 answered 1,7,8 the numbers are codes each answer so 1 is one alternative 2 is another etc. If that helps?