Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula needed for Sum(A1:C1) then Sum(D1:F1) in next cell
I am converting a monthly revenue table to a quarterly revenue table. I would
like to add A1:C1 and put it the result in a new cell and then autofill the cell to the right of it so that it automatically adds D1:F1 for the next value A B C D E F 1 Jan Feb March April May June 2 10 12 12 13 14 15 Qtr1 Qtr 2 Qtr 3 sum A2:C2 Sum D2:F2 Etc... using autofill currently using autofill the first qtr is correct "=Sum(A2:C2) but the next cell gets filled with "=sum(B2:D2) instead of adding the next 3 months. I appreciate anyone's help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Some Help Needed on getting info out of a cell from a formula | New Users to Excel | |||
If Then Formula Help Needed | Excel Worksheet Functions | |||
putting a string from one cell in the formula of another -- indirect needed? | Excel Worksheet Functions | |||
Formula Needed! | Excel Discussion (Misc queries) | |||
Look Up and Cell Reference - Formula Help Needed | Excel Worksheet Functions |