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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a1 reference style and r1c1 style be used in same formula?
"rjagga" skrev i en meddelelse
... 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. rjagga This formula will do the job: =SUM($C$1:$C$5)/OFFSET($C$1:$C$5,(ROWS($C$1:$C$5)-1)+4,-1,1,1) -- Best regards Leo Heuser Followup to newsgroup only please. |
Reply |
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) |