| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 . |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I count occurrences of multiple conditions | Excel Worksheet Functions | |||
| trying to COUNT occurrences when certain criteria is met | Excel Discussion (Misc queries) | |||
| Count number of occurrences | Excel Discussion (Misc queries) | |||
| Count occurrences of values in a column??!! | Excel Worksheet Functions | |||
| Count unique occurrences of name | Excel Discussion (Misc queries) | |||
Linear Mode
