How about

="This person has taken " & COUNTIF(<range,"H") & " holidays off."


HTH,
JP

On Jan 4, 9:44*am, impacter
wrote:
I would like to set up a spreadsheet to record staff leave. *My point of
departure is a calendar in a spreadsheet for 2008 for each employee.
Should the person be sick, I enter an S. *If he takes holiday leave, I
enter an H etc. etc. *Below, or in another sheet/workbook, I will have
cells for this persons holiday, sickness etc. (together with others).

I am looking for a formula/formulas that says, if the value is H, then
increase the number in cell (in another sheet/workbook) with 1. *This
formula will have to be repeated in each workday cell.

The reason for this is to have an exact number of holiday days left
available at all times.

--
impacter