=SUMPRODUCT(--('T&E
Log'!G3:G999=A4),--('T&ELog'!G3:G999<=B4),--('T&ELog'!H3:H999A42))

this is what i did for the 0 days and i'm getting a #ref! error now


--
luckyt22
------------------------------------------------------------------------
luckyt22's Profile: http://www.excelforum.com/member.php...o&userid=24270
View this thread: http://www.excelforum.com/showthread...hreadid=378856