I need to do the following:-

I have 12 worksheets (one for each month) which contain information on staff
members, when they were on duty, when they were on holiday etc.

I have successfully used COUNTIF to work out how many days holiday each
staff member has had at the end of each month (defined by "L"). using

=COUNTIF(D4:AH4, "L")

then dragging the formula down for each staff member.

This has been successful, however some staff members have now left their
job, and the roles have been filled by someone else. Therefore the
information across the worksheets is not consistent.

I want to have a summary for each staff member on a separate worksheet, and
have a running total with how many days leave they have left by counting the
times they have been off and subtracting that from their entitlement (which
is 44 days).

Is there any way i can do an IF function or some sort of lookup reference to
enable me to have a year end total of holiday leave for each individual staff
member??

I'm sorry if this is very confusing, and any help is greatly appreciated!