Can you post a few rows from AbsenceDetail?

John wrote:
Aladin / Don

Getting #values returned, I expect the word 'Holidays'


"Aladin Akyurek" wrote in message
...

In case AbsenceDetail houses text-formatted numbers instead of true
numbers:

=SUMPRODUCT(--(DailyDate=F67),--(StaffNumber=$C$11),--AbsenceDetail)

John wrote:

I am trying to re-jig a formula that shows hours worked for a particular
day, to showing any absence detail shown for a particular employee. I
have the fllowing formula which doesn't work and I'm not sure why. A
similiar formula works for me getting basic hours worked etc

=SUMPRODUCT(--(DailyDate=F67)*(StaffNumber=$C$11),(AbsenceDetail ))

My range names are correct and all have the same 'length'. F67 is
09/05/05; StaffNumber = 100 and the value that is within the
AbsenceDetail cell for the 09/05/05 for # 100 is Holiay, except my
formula returns 0 (I have it formatted as General)

Any ideas appreciated


Thanks




--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.