SUMPRODUCT Function

B

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
 
J

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
 
P

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
 
B

Bob

Thank you works great.

Jacob Skaria said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top