can I have excel count occurrences for 10 people in 7 days
 

I am setting up a physician call schedule.10 people 7days/week. Can I have
excel count how many times each doc has taken call on each day .

can I have excel count occurrences for 10 people in 7 days
 

Need more detail

Biff

"grebnet" wrote in message
...
I am setting up a physician call schedule.10 people 7days/week. Can I have
excel count how many times each doc has taken call on each day .

can I have excel count occurrences for 10 people in 7 days
 

For each day of the month I will put one of 10 different docs on call. It is
important that the number of total calls and number of calls taken for each
day ( ie Mondays,tuesdays.....) are equal . Especially dont want one Doc
doing more weekends than another. So I would like to have a function that
will count How many Mondays Doc X does, how many Tuesdays...... Then total
each up for each month and keep a running total for the year. ( in this
case the year will start April 1st )

Thanks

"T. Valko" wrote:

Need more detail

Biff

"grebnet" wrote in message
...
I am setting up a physician call schedule.10 people 7days/week. Can I have
excel count how many times each doc has taken call on each day .

can I have excel count occurrences for 10 people in 7 days
 

Ok, how about describing your layout.

I assume you have Doc names as one axis and the dates as another axis. Are
the dates real dates like 4/1/2007 or are they the days of the week as TEXT
entries like MONDAY? How do you denote if Doc X has taken a call?

Biff

"grebnet" wrote in message
...
For each day of the month I will put one of 10 different docs on call. It
is
important that the number of total calls and number of calls taken for
each
day ( ie Mondays,tuesdays.....) are equal . Especially dont want one Doc
doing more weekends than another. So I would like to have a function that
will count How many Mondays Doc X does, how many Tuesdays...... Then
total
each up for each month and keep a running total for the year. ( in this
case the year will start April 1st )

Thanks

"T. Valko" wrote:

Need more detail

Biff

"grebnet" wrote in message
...
I am setting up a physician call schedule.10 people 7days/week. Can I
have
excel count how many times each doc has taken call on each day .

can I have excel count occurrences for 10 people in 7 days
 

One column is actual date, next column is day of week, next column is a two
letter code unique to each doc .( ie TR )

"T. Valko" wrote:

Ok, how about describing your layout.

I assume you have Doc names as one axis and the dates as another axis. Are
the dates real dates like 4/1/2007 or are they the days of the week as TEXT
entries like MONDAY? How do you denote if Doc X has taken a call?

Biff

"grebnet" wrote in message
...
For each day of the month I will put one of 10 different docs on call. It
is
important that the number of total calls and number of calls taken for
each
day ( ie Mondays,tuesdays.....) are equal . Especially dont want one Doc
doing more weekends than another. So I would like to have a function that
will count How many Mondays Doc X does, how many Tuesdays...... Then
total
each up for each month and keep a running total for the year. ( in this
case the year will start April 1st )

Thanks

"T. Valko" wrote:

Need more detail

Biff

"grebnet" wrote in message
...
I am setting up a physician call schedule.10 people 7days/week. Can I
have
excel count how many times each doc has taken call on each day .

can I have excel count occurrences for 10 people in 7 days
 

Ok...

Assume A2:A31 = dates for April: 4/1/2007 to 4/30/2007
B2:B31 = various 2 letter codes (initials?)

To count the number of Mondays for "TR":

=SUMPRODUCT(--(WEEKDAY(A2:A31,2)=1),--(B2:B31="TR"))

You can get the other days of the week by changing the 1. 1 = Monday thru 7
= Sunday

Biff

"grebnet" wrote in message
...
One column is actual date, next column is day of week, next column is a
two
letter code unique to each doc .( ie TR )

"T. Valko" wrote:

Ok, how about describing your layout.

I assume you have Doc names as one axis and the dates as another axis.
Are
the dates real dates like 4/1/2007 or are they the days of the week as
TEXT
entries like MONDAY? How do you denote if Doc X has taken a call?

Biff

"grebnet" wrote in message
...
For each day of the month I will put one of 10 different docs on call.
It
is
important that the number of total calls and number of calls taken for
each
day ( ie Mondays,tuesdays.....) are equal . Especially dont want one
Doc
doing more weekends than another. So I would like to have a function
that
will count How many Mondays Doc X does, how many Tuesdays...... Then
total
each up for each month and keep a running total for the year. ( in
this
case the year will start April 1st )

Thanks

"T. Valko" wrote:

Need more detail

Biff

"grebnet" wrote in message
...
I am setting up a physician call schedule.10 people 7days/week. Can
I
have
excel count how many times each doc has taken call on each day .

can I have excel count occurrences for 10 people in 7 days
 

Thanks...Ill give it a try

"T. Valko" wrote:

Ok...

Assume A2:A31 = dates for April: 4/1/2007 to 4/30/2007
B2:B31 = various 2 letter codes (initials?)

To count the number of Mondays for "TR":

=SUMPRODUCT(--(WEEKDAY(A2:A31,2)=1),--(B2:B31="TR"))

You can get the other days of the week by changing the 1. 1 = Monday thru 7
= Sunday

Biff

"grebnet" wrote in message
...
One column is actual date, next column is day of week, next column is a
two
letter code unique to each doc .( ie TR )

"T. Valko" wrote:

Ok, how about describing your layout.

I assume you have Doc names as one axis and the dates as another axis.
Are
the dates real dates like 4/1/2007 or are they the days of the week as
TEXT
entries like MONDAY? How do you denote if Doc X has taken a call?

Biff

"grebnet" wrote in message
...
For each day of the month I will put one of 10 different docs on call.
It
is
important that the number of total calls and number of calls taken for
each
day ( ie Mondays,tuesdays.....) are equal . Especially dont want one
Doc
doing more weekends than another. So I would like to have a function
that
will count How many Mondays Doc X does, how many Tuesdays...... Then
total
each up for each month and keep a running total for the year. ( in
this
case the year will start April 1st )

Thanks

"T. Valko" wrote:

Need more detail

Biff

"grebnet" wrote in message
...
I am setting up a physician call schedule.10 people 7days/week. Can
I
have
excel count how many times each doc has taken call on each day .