| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a1 reference style and r1c1 style be used in same formula?
I need to use a formula like sum(c1.c5)/r[4]c[-1].
Since as and when I add any rows between row 1 & 5 the formula should automatically change to sum(c1.c6) but the cell as a divison should always be the value in the cell 4 rows down in B column. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Puzzled by statement about R1C1 style in "Escape from Excel Hell" | Excel Discussion (Misc queries) | |||
| R1C1 Reference Style won't STAY gone? | Excel Discussion (Misc queries) | |||
| I switched on the R1C1 reference style but I can't switch it off a | Excel Discussion (Misc queries) | |||
| R1C1 reference style | Excel Discussion (Misc queries) | |||
| R1C1 reference | Excel Discussion (Misc queries) | |||
Threaded Mode
