S
sally100
Hi there,
I have a frustrating formula which seems to be right that is giving m
a #value result.
Here goes:
I have 23 sheets in my 1st workbook (Attendance) relating to eac
member of staff. Each sheet has a manually created calendar table.
i.e sub on holiday for jan 1st thru 4th
***Columns****
******J*F*M*A*M*J*J*A*S
**1st...H
**2nd..H
**3rd...H
**4th...H
Each cell relates to a day of each month. I want to enter 'H' fo
holiday in any cell relating to the day the staff member wants annua
leave. I wish to enter other criteria such as 1 for sick, 2 for jur
duty etc..
In my 2nd workbook (Attendance Totals) I have 12 sheets relating to th
months of the year. In each cell I want to display the number of staf
members off on any single day. My formula is as follows ($p$3 relatin
to the cell which holds criteria H):
=COUNTA([Attendance.xls]AH:SW!$C$9,$P$3)
This is counting every entry I put in whether it is numeric or text.
simply want to record the number of staff on leave.
What can I do?
I have a frustrating formula which seems to be right that is giving m
a #value result.
Here goes:
I have 23 sheets in my 1st workbook (Attendance) relating to eac
member of staff. Each sheet has a manually created calendar table.
i.e sub on holiday for jan 1st thru 4th
***Columns****
******J*F*M*A*M*J*J*A*S
**1st...H
**2nd..H
**3rd...H
**4th...H
Each cell relates to a day of each month. I want to enter 'H' fo
holiday in any cell relating to the day the staff member wants annua
leave. I wish to enter other criteria such as 1 for sick, 2 for jur
duty etc..
In my 2nd workbook (Attendance Totals) I have 12 sheets relating to th
months of the year. In each cell I want to display the number of staf
members off on any single day. My formula is as follows ($p$3 relatin
to the cell which holds criteria H):
=COUNTA([Attendance.xls]AH:SW!$C$9,$P$3)
This is counting every entry I put in whether it is numeric or text.
simply want to record the number of staff on leave.
What can I do?