I have come across a problem with a spreadsheet im using for holiday and
sickness tracking.
I have a table with countif working on it, so everytime i put a "h" in the
table it counts as one in the total number of days holiday cell, which is
subtracted from the allowance and the result is displayed in the remaining
days cell.
My problem is, if for example, if i put in 10 days of holiday for someone in
march the remaining days in march will go down, but for the rest of the
months it will stay the same.
How do i link the remaining days on all sheets so that when i put 10 days
holiday in march it takes the remaining number of days down in the rest of
the months sheets.
Thanks for your help,
im not exactly an excel wizard i know.
Darryl

Darryl

Bit more info required maybe..Do the staff have a monthly holiday allowance?
What happens if they don't take their allowance for a given month?

Normally, holiday leave is annual, so calculating the remaining leave at any
given time is trivial and doesn't require COUNTIF (nor a separate sheet for
each month). If you have columns for From (date), To (date), and Days taken
Just sum the Days taken column and subtract from the annual allowance.

Phil


"Darryl" wrote in message
...
I have come across a problem with a spreadsheet im using for holiday and
sickness tracking.
I have a table with countif working on it, so everytime i put a "h" in the
table it counts as one in the total number of days holiday cell, which is
subtracted from the allowance and the result is displayed in the remaining
days cell.
My problem is, if for example, if i put in 10 days of holiday for someone
in
march the remaining days in march will go down, but for the rest of the
months it will stay the same.
How do i link the remaining days on all sheets so that when i put 10 days
holiday in march it takes the remaining number of days down in the rest of
the months sheets.
Thanks for your help,
im not exactly an excel wizard i know.
Darryl

What formulae are you using? Logically, if the total for March after the
deductions is the start total for April etc., then all will be OK

"Darryl" wrote:

I have come across a problem with a spreadsheet im using for holiday and
sickness tracking.
I have a table with countif working on it, so everytime i put a "h" in the
table it counts as one in the total number of days holiday cell, which is
subtracted from the allowance and the result is displayed in the remaining
days cell.
My problem is, if for example, if i put in 10 days of holiday for someone in
march the remaining days in march will go down, but for the rest of the
months it will stay the same.
How do i link the remaining days on all sheets so that when i put 10 days
holiday in march it takes the remaining number of days down in the rest of
the months sheets.
Thanks for your help,
im not exactly an excel wizard i know.
Darryl