Counting Entries in a Cell

S

Sh0t2bts

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top