sgmpatnaik
Active Member
Hello
i have small problem that is i want to add the Start Date and End Date in a Sumproduct Formula as a extra Critera
my formula is
The Date Columns in Dispatch Register is Column C and start date and End date column Range is H5
Kindly suggest me
Thanks
i have small problem that is i want to add the Start Date and End Date in a Sumproduct Formula as a extra Critera
my formula is
Code:
=SUMPRODUCT(('Dealer List'!$C$6:$C$50=$C9)*('Dealer List'!$H$5:$I$5=F$7),'Dealer List'!$H$6:$I$50)+SUMPRODUCT(('Dispatch Register'!$F$6:$F$3490=$C9)*('Dispatch Register'!$O$6:$O$3490=F$7),'Dispatch Register'!$N$6:$N$3490)-SUMPRODUCT(('Dispatch Register'!$F$6:$F$3490=$C9)*('Dispatch Register'!$O$6:$O$3490=F$7),'Dispatch Register'!$L$6:$L$3490)
The Date Columns in Dispatch Register is Column C and start date and End date column Range is H5
Kindly suggest me
Thanks