When I am entering data on row 9 cells (b9,c9,d9,e9,f9,g9) that data is
totaled with formula's in cells l9,m9 and n9. I want the same exact totals
to show in cells l15,m15, and n15 but when data is entered in to row 10 and
totaled with formula's in l10,m10, and n10 I want the totals in l15,m15 and
n15 to show what l10,m10, and n10 now has and not l9,m9, and n9

"ufo_pilot" wrote:

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