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