Thanks Bob, what I want is whatever value is within the field associated
with the Range Name AbsenceDetail that equates to the DailyDate &
StaffNumber

Can't use hardcoded value of "Holidays' becuase there are quite a number of
different values that can be returned within the AbsenceDetail field



"Bob Phillips" wrote in message
...
You cannot sum text. And what if many cells c ontain Holiday, what do you
want then? Or some don't.

Maybe you want

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


--
HTH

Bob Phillips

"John" wrote in message
...
Thats correct Bob, it contains Holiday and returns 0, but I want it to
return 'Holiday'


"Bob Phillips" wrote in message
...
Are you saying that the AbsenceDetail cell contains the text Holiday?
If
so,
that will sum as 0.

--
HTH

Bob Phillips

"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