That should work okay. Do you get the problem with the workbook open,
closed, or both?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"shakey1181" wrote in message
...
I am using the following formula to reference another file and count the
number of entries in the array:

=SUMPRODUCT(--('Z:\2006\06''06\[01.06.06.XLS]delays & pax'!$E$7:$E$270))

the above is returning 20, which is a count of the size of the array
rather
than the number of entries greater than zero. I have used a similar
formula
on the same sheet and it's working perfectly, but however I alter the
above,
it only ever returns 20.

Any Ideas?