Using SUM with un-adjacent cells, and then filling a table

I'm compiling survey data from different locations. In WorkSheet1, the rows are the survey questions and response options (a scale of 1 to 5 for each question), the columns are the locations. The cells are how many people responded to each option at each question at each location.

In WorkSheet2, I'm trying to create a condensed table with rows as survey questions, columns as locations, and cells as how many total people responded to the questions at the locations.

I want to create a SUM formula in the WorkSheet2 cells that will sum the values from WorkSheet1. However, the values are not adjacent to each other. The responses for the first question are C20:C24, second question C27:C30, and so on. How can I create a SUM formula and then fill it to the rest of the table?

Thank you!

Survey.xls

Hello
Take a look at the formulas for Main Library in the attachment. You can amend them for the other ranges.

Hope this helps.

Wow that's pretty awesome, and definitely not in the same direction I was going in. Thanks!