=SUM(START:END), Copy/Paste and/or a Macro
To save typing a formula for each list you could in your first 'result cell', you can use
=SUM(B4:B10). For example:
Then copy and paste this formula into the other 'result cells', and the formula will update the references. This assumes that the lists you are summing are the same length, of course.
If you are running this repeatedly - eg for reports - recording a macro will help automate the process.
When you record a macro, the macro recorder records all the steps in Visual Basic for Applications (VBA) code. These steps can include typing text or numbers, clicking cells or commands on the ribbon or on menus, formatting cells, rows, or columns, or even importing data from an external source, say, Microsoft Access.
If you want to write your own macro, it's worth looking at the
ActiveCell.Formula[A/R1C1], along the lines of:
Worksheets("yourworksheet").Range("ResultCell").Formula = "=SUM(Range1:Range2)"
Replacing and inserting
ResultCell as necessary.
There are plenty of resources out there; you might want to consider a resource on formulae (from wikibooks). From that page:
Formulas used in spreadsheets, automatically process data how the user see fits. The formula takes data from certain areas in the spreadsheet, processes it, and places the output into the new area of the spreadsheet based on where the formula is written. The formula can be as simple as "=SUM(A10,A11)" (which takes the information in the 10th and 11th cells of row A and outputs the sum), or as complex as the user wishes to make it. The functions used to create the formula (such as SUM), are predesignated by the spreadsheet software.
It's worth doing some background reading as it can make solving future problems much simpler.
Microsoft have a page on different ways to add values too; but
SUM should do you fine in this case.