Domenic Wrote:
Can be shortened to...

=SUMPRODUCT((Weeks!$M$1:$M$10=$B6)*(Weeks!$B$1:$K$ 10=C$5))

Hope this helps!


Ty this helped a lot. Sped the processing of it right up.


--
masterkeys