Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
incrementing on inserrt row
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
incrementing | Excel Worksheet Functions | |||
Incrementing by 1 in every other column | Excel Worksheet Functions | |||
incrementing | Excel Discussion (Misc queries) | |||
Incrementing numbers | Excel Worksheet Functions | |||
Getting the last value of an incrementing sheet | Excel Worksheet Functions |