=SUMPRODUCT(--(A1=L1:L9),--(B1=M1:M9),--(B1<=N1:N9),O1:O9)
.. it sticks a 0 regardless of the emp and date entered.
Your expression is ok. But probably the return col O contains text nums,
which sumproduct cannot evaluate.
You could try this more generic index/match equivalent (normal ENTER to
confirm will do, like the sumproduct) which will work regardless of whether
its nums, text or mixed data in the return col:
=INDEX(O2:O9,MATCH(1,INDEX((A1=L2:L9)*(B1=M2:M9)* (B1<=N2:N9),),0))
Do high-five this response by clicking the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---