Try the below.

=SUMPRODUCT(--(PreProduction!$H$6:$H$5000=DATE(2006,6,5)),
--(PreProduction!$H$6:$H$5000<=DATE(2006,12,31)),
--(PreProduction!$K$6:$K$5000="Frank"),PreProduction !$F$6:$F$5000)

If this post helps click Yes
---------------
Jacob Skaria


"Bob" wrote:

Im am using the following function and it works fine:
=SUMPRODUCT(--(PreProduction!$H$6:$H$5000=DATE(2006,6,5)),--(PreProduction!$H$6:$H$5000<=DATE(2006,12,31)),Pre Production!$F$6:$F$5000)

However after that date range I would also like to find Peoples names in
Column K before adding Column F
Something like:
=SUMPRODUCT(--(PreProduction!$H$6:$H$5000=DATE(2006,6,5)),--(PreProduction!$H$6:$H$5000<=DATE(2006,12,31))PreP roduction!$K$6:$K$5000="Frank",PreProduction!$F$6: $F$5000)

How do i write the function so it works? Thank you