Home |
Search |
Today's Posts |
#1
|
|||
|
|||
variable as a cell reference?
i have this formula (and some others like it) that are basically summing
from the 24th row to the bottom row of a list of items, which in this case is row 203. =+SUMIF($A$24:$A$203,A5,$L$24:$L$203) i continually add items into the list so i am continually having to do 'insert row' into the spreadsheet so as to maintain the pointer to the last row, ie 203, which then becomes 204, 205...221. is it possible to make the $A$203 be $A$BottomRow where BottomRow can then be changed to whatever i want. i guess i would define a cell name to be BottomRow and then fill in whatever value i need. would avoid having to do all those inserts. Or perhaps more simply i could put a special character value lets say 'bottom' and have excel scan column A from top to 99999 looking for the word 'bottom' and then using that row to be the value of BottomRow. hope this is clear. thanks. jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions | |||
Cell reference - for the sheet name, can I use a variable? | Excel Discussion (Misc queries) | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |