I am working in Microsoft Excel 2003. I am trying to sum certain ranges in
multiple lines of data. An example of my spreadsheet is below. The way it
is now, the "END BALANCE" row is not including the amount in the CDU field
(row 1 and 8). I need to be able to sum rows 1-5 with results on row 6 and
then sum rows 8-14 with results on row 15, etc. Any ideas?

A B C
1 NAME CDU 3.42
2 INCOME 1.31
3 BOND 1.29
4 BALANCED 5.42
5 LARGE-CAP 3.05
6 END BALANCE 11.07
7 0
8 NAME CDU 5.42
9 INCOME 6.31
10 BOND 18.29
11 BALANCED 53.42
12 LARGE-CAP 35.05
13 MID-CAP 2.00
14 WORLD 5.00
15 END BALANCE 120.07