0 (Zero), or I had it formatted in Time format 12:00am


"Harlan Grove" <hrlngrv@aol.com> wrote in message
news:1145596542.046978.197750@e56g2000cwe.googlegroups.com...
> John wrote...
>>Thanks Harlan for your guidance, problem now is it returns a #N/A value.
> ...
>
> What does the formula
>
> =SUMPRODUCT((Date_HoursWorked=H$9)*(StaffNo_HoursWorked=$B$13))
>
> return?
>