Hi danny,

Assuming row 9 sums the previous 8 rows, then, in I9 you'd use a formula like:
=SUM(I1:I8)
To have row 15 reflect this and any data added to rows 11-14, then, in I15 you'd use a formula like:
=SUM(I9:I14)

If this isn't what you want, you'll have to provide more information about which ranges are being summed in l9, m9, and n9 and in
l15, m15, and n15.

Cheers

--
macropod
[MVP - Microsoft Word]


"danny boahn" wrote in message ...
| I am working on a spread sheet that is starting in row 9. That data get total
| in cells l9, m9, and n9 with a formula. I want the exact totals from l9, m9,
| and n9 to appear in cells l15, m15 and n15. But when data is entered in to
| row 10 and totaled in l10, m10 and n10 I want l15, m15 and n15 to change to
| reflex the totals in l10, m10 and n10 then row 11, row 12, and row 13. When
| data is entered and totaled cells l15, m15, and n15 reflex's the last entered
| row