try this

Keep Row 1 blank

in D2 put this formula and drag it down =IF(A3=0,(SUM($C$2:C2)-SUM($D
$1:D1)),"")



On Nov 26, 10:46*pm, darkfeld
wrote:
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