Hi All,

I have a workbook that we use for keeping track of Staff.

In column A2:A50 I have their Full Names
Column B2:B50 I have their initials
Column C2:C50 Total Number of days training using this formula
"=COUNTIF(Courses,"*" & $P10 & "*") - (COUNTIF(Courses,"*" & $P10 &
"1/2" & "*")/2)"
Courses is a difined name as "=Sheet1!$B$3:$M$33"

Columns B60:M60 I have diffrent Courses
Rows A61:A92 I have dates

As this is for 100+ people it is getting difficult to count how many
people are on a training course on any given date, What I am after
doing is in another work sheet replicating the calander but in stead of
having the attendees initials visable to just show the total number

Can anyone help with this??

Many Thanks

Mark

A B C
2 Fred Jones FJ 2
3 Joe BLoggs JB 1.5

A B C
50 01/06/05 Excel Word
51 02/06/05 FJ,JB1/2 JB,FJ