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