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

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"How can I alphabetize a list of names in" <How can I alphabetize a list of
names wrote in message
...


"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