Two-Way Tables

Occasional Contributor

Would like to know how to generate a two-way table to display: Count of students by Gender and Origin


Excel spreadsheet attached for reference. 

1 Reply
best response confirmed by svaydtla (Occasional Contributor)

@svaydtla not sure what exactly you want but in the attached I created 2 total columns.  1 for all unique Gender and 1 for all unique Origins and then countif for each.  But the easier way that also give a full table of every combination is to do a pivot table of this information.  Also in the attached and done using these steps:

a) highlighted those 2 columns

b) selected Insert pivot table and selected cell where to put it

c) dragged gender and origin to rows and columns boxes and then origin (or gender) to the  Values box

d) right click on pivot table and selected Pivot Table Options and clicked tab for totals and selected to show Grand totals for rows and columns