| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
repeat summing?
I am setting up a List and have some numbers to add up. I know how to do this
but my question is if there is a way to repeat Example =SUM(A2:A10) ((Results are in Cell (A11) Is there a way to have this Repeat for the next rows automaticlly? row b =SUM(B2:B10) ((Results are in Cell (B11) row C =SUM(C2:C10) ((Results are in Cell (C11) row d =SUM(DB2:D10) ((Results are in Cell (D11) row D |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
repeat summing?
Copy cell A11 and paste to the other locations. The references will
automatically change (ie reference to A in column A will become B in column B etc. -- Ian -- "Jesse Dean" <Jesse wrote in message ... I am setting up a List and have some numbers to add up. I know how to do this but my question is if there is a way to repeat Example =SUM(A2:A10) ((Results are in Cell (A11) Is there a way to have this Repeat for the next rows automaticlly? row b =SUM(B2:B10) ((Results are in Cell (B11) row C =SUM(C2:C10) ((Results are in Cell (C11) row d =SUM(DB2:D10) ((Results are in Cell (D11) row D |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
repeat summing?
Thanks That worked Great. I tried to find that solution in the help menu and
it seems that they neglected that bit of information "Ian" wrote: Copy cell A11 and paste to the other locations. The references will automatically change (ie reference to A in column A will become B in column B etc. -- Ian -- "Jesse Dean" <Jesse wrote in message ... I am setting up a List and have some numbers to add up. I know how to do this but my question is if there is a way to repeat Example =SUM(A2:A10) ((Results are in Cell (A11) Is there a way to have this Repeat for the next rows automaticlly? row b =SUM(B2:B10) ((Results are in Cell (B11) row C =SUM(C2:C10) ((Results are in Cell (C11) row d =SUM(DB2:D10) ((Results are in Cell (D11) row D |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
repeat summing?
Jesse
Hard to find things in Help unless you know the keyword to type in. Under "copying" I found this entry.......... "Move or copy cells and cell contents" Instructions quite complete. Gord Dibben MS Excel MVP On Sat, 26 Aug 2006 03:41:02 -0700, Jesse Dean wrote: Thanks That worked Great. I tried to find that solution in the help menu and it seems that they neglected that bit of information "Ian" wrote: Copy cell A11 and paste to the other locations. The references will automatically change (ie reference to A in column A will become B in column B etc. -- Ian -- "Jesse Dean" <Jesse wrote in message ... I am setting up a List and have some numbers to add up. I know how to do this but my question is if there is a way to repeat Example =SUM(A2:A10) ((Results are in Cell (A11) Is there a way to have this Repeat for the next rows automaticlly? row b =SUM(B2:B10) ((Results are in Cell (B11) row C =SUM(C2:C10) ((Results are in Cell (C11) row d =SUM(DB2:D10) ((Results are in Cell (D11) row D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat last action | Excel Worksheet Functions | |||
| repeat rows for add'l pages for tabs on a multi-tab worksheet | Excel Worksheet Functions | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
| How to make repeat long numbers shortcut ? | Excel Worksheet Functions | |||
| How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
Linear Mode
