Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |