I have a spreadsheet which consists of a separate worksheet for each month.

Each worksheet is holding data about the number of days a person is absent
and the number of occasions. For example, if a person has a whole week off
this will show as 5 days absent on one occasion.

At the end of each sheet is a column with totals the number of days and
another totals the number of columns. This data is then transferred to a
summary sheet which comprises pairs of colums containg the total days lost in
each month, and the total instances each month.

My problem comes when somebody is absent over the end of one month and the
start of the next. I need some way for the Summary sheet to recognise this as
one instance of absence. Putting one instance in each monthly sheet distorts
the average figure that I am calculating.


--
Nick

It would be be helpful to know a couple of things.
Does on the worksheet total the numbers each month or is there a "Recap"
page you are using?
Which month do you want to count the number of occurances. i.e. the month in
which the first day off was taken or the following month?
I'm assuming you are using an excel formula to tabulate the numbers. What
formula are you using?


"Nick" wrote:

I have a spreadsheet which consists of a separate worksheet for each month.

Each worksheet is holding data about the number of days a person is absent
and the number of occasions. For example, if a person has a whole week off
this will show as 5 days absent on one occasion.

At the end of each sheet is a column with totals the number of days and
another totals the number of columns. This data is then transferred to a
summary sheet which comprises pairs of colums containg the total days lost in
each month, and the total instances each month.

My problem comes when somebody is absent over the end of one month and the
start of the next. I need some way for the Summary sheet to recognise this as
one instance of absence. Putting one instance in each monthly sheet distorts
the average figure that I am calculating.


--
Nick