| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Sum formula to different row but use same column data
I have the following data and am trying to copy the sum function to create a
running total. When I copy the formula it keeps the same column and I need it to jump to the subsequent column. Assume this data is in columns A and B starting in A1. 1 5 =sum(A1:A4) 2 6 =sum(b1:B4) This is what I want to happen but when I copy the 3 7 formula in C1 to C2 it keeps the formula in the A 4 8 column and just switches the range. Is there any way to have it jump to the next column without having to manually change it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a formula down a column | Excel Worksheet Functions | |||
| Copy Data from one Column to another | Excel Discussion (Misc queries) | |||
| How to copy the data in row to column? | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Threaded Mode
