problem with array formula

[arnab0711]

Hi,
I have this array formula in sheet snap of the workbook,which search for B3,B4 and A5 in OR sheet and give the result,but now its giving 0 as result please advice.

[Bob Phillips]

Perhaps it should be

=SUMPRODUCT((OR!$B$5:$B$3290=$B$2)*(OR!$A$5:$A$3290=$B$3)*(OR!$E$5:$E$3290= $A5)*(OR!$F$5:$F$3290=1))

[Bob Phillips]

But actually

=SUMPRODUCT((OR!$B$5:$B$3290=$B$2)*(OR!$A$5:$A$3290=$B$3)*(OR!$E$5:$E$3290= $A5))

works just as well

[arnab0711]

Thanks,appreciated.