Pivot Running Total Question

[UniMord]

#VALUE!

Excel 2010

Cell Formulas
Range	Formula
E2	=IF(LEN(A2)+(RIGHT(B2, 6)=" Total"), D2, SUM(E1, D2))
E3	=IF(LEN(A3)+(RIGHT(B3, 6)=" Total"), D3, SUM(E2, D3))
E4	=IF(LEN(A4)+(RIGHT(B4, 6)=" Total"), D4, SUM(E2, D4))
E5	=IF(LEN(A5)+(RIGHT(B5, 6)=" Total"), D5, SUM(E4, D5))
E6	=IF(LEN(A6)+(RIGHT(B6, 6)=" Total"), D6, SUM(E5, D6))
E7	=IF(LEN(A7)+(RIGHT(B7, 6)=" Total"), D7, SUM(E6, D7))
E8	=IF(LEN(A8)+(RIGHT(B8, 6)=" Total"), D8, SUM(E7, D8))
E9	=IF(LEN(A9)+(RIGHT(B9, 6)=" Total"), D9, SUM(E8, D9))

Any help will be appreciated.

 

[UniMord]

I hate to bump, but, bump!

(Just for the record, before I get corrected, I realized after I sent the above table, that the running totals column's formula could've been simplified:
=IF(LEN(A4&B4), D4, SUM(E3, D4)).)