<LOL
-----Original Message-----
Smart-ass :-)
I think I might just use that!
Regards
Bob
"Jason Morin" wrote
in message
...
Same concept as what Bob's given you, just shorter:
=SUMPRODUCT(ISNUMBER(FIND({"l","L"},D1:D20))*{0.5, 1})
HTH
Jason
Atlanta, GA
-----Original Message-----
I am trying to create a spreadsheet showing annual
leave
in a workbook. I
have used countif to calc number of days. but how do
i
show half days using
formulas.
many thanks
Richard.Gayle
.
.
|