Thanks Harlan, I created a "white cell" in H8 with Home!$K$12-5 etc and left
H9 visible and worked the formula off of H8


"Harlan Grove" <hrlngrv@aol.com> wrote in message
news:1145642083.092860.108020@u72g2000cwu.googlegroups.com...
> John wrote...
>>This #N/A maybe caused by the way I produce the value in H(, which has the
>>following
>>
>>="("&TEXT((Home!$K$12-5),"dd/mm/yy"&")")
>>
>>Maybe Im just trying to be too clever. When I just type a date in H9 it
>>returns a value of 1 in the formula
>>
>>"John" <r.@9999yahoo.co.uk> wrote in message
>>>0 (Zero), or I had it formatted in Time format 12:00am
>>>
>>>"Harlan Grove" <hrlngrv@aol.com> wrote in message
> ...
>>>>What does the formula
>>>>
>>>>=SUMPRODUCT((Date_HoursWorked=H$9)*(StaffNo_HoursWorked=$B$13))
>>>>
>>>>return?
>
> You're getting #N/A errors because of your H9 value and maybe also your
> B13 value. It seems Date_HoursWorked is a range containing date values.
> If so, it'd never equal the text value given by the formula you show
> above. In Excel, numbers never equal text. Replace the H9 formula with
>
> =Home!$K$12-5
>
> and format it as you see fit.
>