Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello, Experts,
I wanted to make array formula in multiple cells with relative references, such as: In cell C1: {=SUM(LEN(A1:A5))} In cell C2: {=SUM(LEN(A2:A6))} In cell C3: {=SUM(LEN(A3:A7))} In cell C4: {=SUM(LEN(A4:A8))} In cell C5: {=SUM(LEN(A5:A9))} .... .... .... but when I highlited range C1:C5 and enter the array by presss Control/Shift/Enter, the array formula in these cells became {=SUM(LEN(A1:A5))}. Is there some way to force the array formula to adopt relative reference? thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing relative to a formula reference | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Formula needs to reference anchored relative cell | Excel Programming | |||
Using Relative Reference in a Formula | Excel Programming | |||
Mixing Absolute and Relative Reference in a Formula | Excel Programming |