| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula with in cell reference
A1 =5 B1=3
A2 =65 A3=12 .... .... How can I do this: I want C1 have formula to do this: the sum of A1 to A3 but if B1 change to 5 then C1 = sum(A1:A5) and when B1 change to 100 C1=sum(a1:A100) ie. change the reference formula according to B1. I have tried C1=sum(a1:A(B1)) but it does not work. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula with in cell reference
Hi,
Use : =SUM(A1:OFFSET(A1,B1,0)) HTH |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula with in cell reference
Thanks Carim. You are very helpful.
"Carim" wrote in message ... Hi, Use : =SUM(A1:OFFSET(A1,B1,0)) HTH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| Using a cell reference within a cell reference in a formula | Excel Worksheet Functions | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
