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

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