| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add formula next to corresponding cells
I would like to add the following formula "=SUM(RC[1]:RC[2])" in cells
starting H2 to H10 next to cell G2:G10 row 10 can vary - i,e adding the following formula "=SUM(RC[1]:RC[2])" in cells starting H2 to H100 next to cell G2:G100 Can any bod help (i,e i would like to offset 1 column & add formula next to corresponding cells. Thxs |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula refers to empty cells even when cells contains data | Excel Worksheet Functions | |||
| Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
| Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement | Excel Programming | |||
Threaded Mode
