You could do

=SUMIF(INDIRECT("A24:A"&BottomRow),A5,INDIRECT("L2 0:L"&BottomRow))

or if there is nothing below, and you don't have lots of these formulae, you
could just use

=SUMIF($A$24:$A$65536,A5,$L$24:$L$65536)
--

HTH

RP
(remove nothere from the email address if mailing direct)


"jim sturtz" wrote in message
...
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