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

G

grebnet

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 .
 
G

grebnet

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

T. Valko

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
 
G

grebnet

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

T. Valko

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
 
G

grebnet

Thanks...Ill give it a try

T. Valko said:
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
Click to expand...
 
Top