Pivot tables are great when you want to play with your data. Well, you can use pivot tables instead of subtotals (there are subtotals in pivot tables too). And, there are some styles and formats that you can use; Excel 2007 has much more styles and formatting options.
I thought you want the summary in your data sheet, and only sum, so I thought of subtotals. If you want your data and summary report in different sheets, pivot table offers more advantages. You can also place pivot table in the same sheet of the data sheet though.
I would like to suggest some things if you’re going to use pivot table. When you’re creating pivot table, you need to enter the input range where your data is. If you enter your data frequently, you’ll have to make changes in your input range from time to time. To avoid this, you may either go for named dynamic range that makes use of OFFSET function or you may use lists/tables. (In Excel 2003, it’s called “List” and it is in Data->List; whereas in Excel 2007, it is called just “Table”, Insert tab->Pivot table/Table. In VBA, it is List object in both Excel 2003 and 2007.)
Dynamic range is useful in creating dynamic charts also, here, I think, List/Table would be more easier for you.
1. To create List/Table, select your data range and create the list from the above menu paths.
2. When creating pivot table, just type the name of your List/Table (you may name it or use the defaults) in where you enter the input range for the pivot table.
(If you’re using dynamic range, paste the name of the dynamic range here)
3. Rest proceed as usual.
So now, when you make changes (add/insert rows, etc.), just go in pivot table and click “Refresh All”, it will take care; you need not worry about the changed data range.