you could use INDIRECT

=INDIRECT("A"&C1)

where C1 contains the row number.

you could also look at dynamic named ranges

http://www.cpearson.com/excel/excelF.htm#DynamicRanges


"SD" wrote:

Hi there,

I have a forumula

=SUM(IF('SCHEDULED INJ'!$AL$2:$AL$55=D3,1,0)*IF('SCHEDULED
INJ'!$H$2:$H$55="30000001PC",1,0)*('SCHEDULED INJ'!$AM$2:$AM$55))

My problem is: because it is an array the row number 55 needs be the last
line (ie there cant be any blanks after the last bit of data). This formula
references a query so the number of rows changes daily, one day it might be
70 next 55. How can I get this to reference the exact number of rows in
"scheduled inj "worksheets.

I have a row count set up but need this formula to reference it.

cheers

SD