Hi!

Each cell in the arrays:

AL2:ALn=D3
H2:Hn=30000001PC

will return either TRUE or FALSE.

The "--" converts those to either 1 for TRUE or 0 for FALSE.

Then you end up having all 3 arrays multiplied together then summed for the
final result:

1*0*10=0
1*1*20=20
0*1*10=0
0*0*20=0

Result = 20

Biff

"SD" wrote in message
...
Thanks very much...can i ask what the -- means next to indirect???

"Biff" wrote:

Hi!

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).

I don't understand your reasoning, but, try this:

A1 = row count

Normally entered, not an array:

=SUMPRODUCT(--(INDIRECT("'SCHEDULED
INJ'!AL2:AL"&A1)=D3),--(INDIRECT("'SCHEDULED
INJ'!H2:H"&A1)="30000001PC"),INDIRECT("'SCHEDULED INJ'!AM2:AM"&A1))

Biff

"SD" wrote in message
...
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