Still working on this one

I'm using the below formula in the table (My Reference in Col A and
Dates in Row 1 e.g 1/7 to 31/7) to count the references that match each
day

=SUMPRODUCT(--(July06!$D$2:$D$247<=$B$1)*(July06!$Y$2:$Y$247=$B $1)*(July06!$C$2:$C$247=Sheet2!$A2))

Where B1 = 1/7/06 and so on and A2 to A20 contains my reference.

Questions.

Can I use this to read data from a closed workbook.
How big will it be for 12 months with 20 references.
Is this the neatest solution

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561464