Thread
:
incrementing on inserrt row
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
incrementing on inserrt row
because 54 is not a cell address. Try using indirect and rows() as in:
=SUM(INDIRECT("b2:b"&ROWS(3)))
--
Don Guillett
SalesAid Software
"Becky" wrote in message
...
In the following code, how can i get the numbers 54 to
automatically increment to 55when i insert a new line. For
some reason this does not happen, however, the number 63
does increase to 64.
=HLOOKUP('Project Summary'!B1,OFFSET('Associates Hours
(actuals)'!$S$5:$AD$63,0,0,COUNTA('Associates Hours
(actuals)'!$S$5:$AD$63)),54,TRUE)*30
Many thanks
Becky
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]