SUMPRODUCT Function

[Bob]

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)),PreProduction!$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))PreProduction!$K$6:$K$5000="Frank",PreProduction!$F$6:$F$5000)

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

 

[Jacob Skaria]

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

 

[Per Jessen]

Hi Bob

This should do it:

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

Regards,
Per

 

[Bob]

Thank you works great.

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