Column M
row 10 =SUM(A10:L10) all of these total from col A through col L
row 11 =SUM(A11:L11)
row 12 =SUM(A12:L12)
row 13 =SUM(A13:L13)
row 14 =SUM(A14:L14)
row 15 =SUM(M10:M14) ( totals rows 10-14)

Now I'm not certain what you are having totaled in cells m9,n9,o9.
If you need the same results in column N and O as in M, then just use the
EXACT same numbers and letters in the "( )" of the formula, if not, then you
need to edit.

"danny boahn" wrote:

I am working on a spread sheet. I am entering data on row 9. I am having that
data totaled in cells m9,n9,o9. I want that data to show in cells
m15,n15,o15. But when new data is entered on row 10 then totaled in
m10,n10,o10 I want those cells to appear in m15,n15,o15. The totals in
m15,n15,o15 will change up to 5 times when new data is entered into rows
9,10,11,12,13

Hope you Can Help

Danny