Question

Using Excel, how could I display the total number of responses to each level of the survey scale across all regions for each year and, more specifically, what formula would I use? Is it SUMif?

Survey Scale:	0	1	2	3	4	5	Sample
North America							Size
2010	1	0	2	14	22	11	50
2011	0	0	2	14	20	14	50
2012	1	1	1	8	34	15	60
2013	1	2	6	12	34	45	100
2014	2	3	5	15	44	56	125
South America
2010	0	0	0	2	6	2	10
2011	0	0	0	2	6	2	10
2012	0	0	1	4	11	14	30
2013	0	1	1	3	12	33	50
2014	1	1	2	4	22	60	90
Europe
2010	0	0	1	3	7	4	15
2011	0	0	1	2	8	4	15
2012	0	0	1	2	15	7	25
2013	0	0	1	2	21	6	30
2014	0	0	1	4	17	8	30