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

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