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! |
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) |