Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of Different Ranges Keeping Results In Sequential Columns
This is what I'm trying to do:
=Sum(A1:D1) with the result being in A5 - Now I want to copy or drag, so I don't have to keep retyping, the formula in A5 to B5 with results being =Sum(E1:H1) This way I can see all the sumed ranges without having to scroll over. Any suggestions? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of Different Ranges Keeping Results In Sequential Columns
In A5: =SUM(OFFSET($A$1,0,(COLUMN()-1)*4,1,4))
copy across "CONCLA2" wrote: This is what I'm trying to do: =Sum(A1:D1) with the result being in A5 - Now I want to copy or drag, so I don't have to keep retyping, the formula in A5 to B5 with results being =Sum(E1:H1) This way I can see all the sumed ranges without having to scroll over. Any suggestions? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of Different Ranges Keeping Results In Sequential Columns
Non-volatile approach:
=SUM(INDEX($1:$1,4*COLUMNS($A:A)-3):INDEX($1:$1,COLUMNS($A:A)*4)) ..And copy across as needed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "CONCLA2" wrote in message ... This is what I'm trying to do: =Sum(A1:D1) with the result being in A5 - Now I want to copy or drag, so I don't have to keep retyping, the formula in A5 to B5 with results being =Sum(E1:H1) This way I can see all the sumed ranges without having to scroll over. Any suggestions? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et | Excel Worksheet Functions | |||
Rounding results by ranges | Excel Worksheet Functions | |||
Keeping track of results of refreshed/updated data | Excel Worksheet Functions | |||
How do I do a VLOOKUP from 2 ranges and add the results together? | Excel Worksheet Functions | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) |