Try to sum absencedetail

=SUMPRODUCT((DailyDate=F67)*(StaffNumber=$C$11)*Ab senceDetail)

--
Don Guillett
SalesAid Software

"John" wrote in message
...
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