Hi, not sure if this can be done but here goes:

I am creating a attendance spreadsheet (oh such fun) and need to add
staff holidays, and also TOIL to the list.

At the end of the row (for each member of staff) I need to add how many
days holiday has been taken, and in a seperate column how many days
TOIL.

I want to keep the sheet very simple (the CEO needs to be able to
understand it!) and therefore want to be able to use the simple method
of "H" or "T" to indicate Holiday or TOIL - simple enough so far. This
would be easy as I would use the COUNTIF function but ...

... staff also take half day holidays and TOIL.

So, is there anyway at all of stating that H1/2 = 0.5 and H=1 and then
adding the range together?

Hope this all makes sense - beginning to think that it just can't be
done.

Cheers


--
sbg1275
------------------------------------------------------------------------
sbg1275's Profile: http://www.excelforum.com/member.php...o&userid=24685
View this thread: http://www.excelforum.com/showthread...hreadid=382566