| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incrementing Formula by Column Instead of by Row
In one worksheet I have the formula: =SUM(Data!B5:B78) referencing data in a
column on another worksheet. I want to drag the formula down to the next row so that it will read: =SUM(Data!C5:C78), the row after =SUM(Data!D5:D78)...etc. Without dollar signs it increments by row as it should. When I add in dollar signs like so: =SUM(Data!B$5:B$78) and I try to drag it down, it just copies that exact formula to the cell below it like I typed: =SUM(Data!$B$5:$B$78) even though I didn't. How do I get Excel to do what I want. I am using Excel 2003. I've searched everywhere and I can't find an answer. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incrementing numbers in a column | Excel Discussion (Misc queries) | |||
| Incrementing by 1 in every other column | Excel Worksheet Functions | |||
| Incrementing a hexidecimal column | Excel Discussion (Misc queries) | |||
| incrementing column symbols orthogonally? | Excel Worksheet Functions | |||
| incrementing formula reference by 7 | Excel Discussion (Misc queries) | |||
Threaded Mode
