2 Replies Latest reply on Aug 27, 2012 7:26 AM by George Gorczynski

    How do I combine counts from different columns?

    George Gorczynski

      Hi All,

       

      I need a way to combine data in different columns.

       

      Please have a look at the attached sample spreadsheet. It is a survey where each row corresponds to data from a single household with (in this sample) 2 people per household interviewed. Hence 2 columns each for ***, age, education, birthplace and residence in 2006.

       

      I need to graph a total number of people in each community, by, let's say place of birth. How can I combine data for Person 1 and Person 2 for each category?

       

      Thank you in advance,

       

      George