Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting capacity based on technician schedule
Hopefully someone can help me
The formula I'm trying to figure out is to be able to count how many jobs a tech can do based on his schedule. Below is listed an example of how techs can be scheduled. Each letter means he can do 2 orders for that time interval. A = am orders, P= pm orders, & E = eve orders. So on day 1 the first tech scheduled AP can do 2am orders and 2pm orders, the second tech can do only 2 pm orders..and so on. I want a formula that based on a range of technicians schedules can say in a cell or cells...that for Day 1...we have the ability to do 2 am orders and 4 pm orders. U##### AP AP P E AE APE AP U1#### P A A AP APE P P i hope this is clear enough |
#2
|
|||
|
|||
I can't follow your question, but I think you have columns for a time and
you are looking to make sure that you have at least one A in each of several columns. see use of COUNTIF Excel Developer Tip: Summing and Counting Using Mutliple Criteria http://www.j-walk.com/ss/excel/tips/tip74.htm F10: =COUNTIF(F$2:OFFSET(F10,-1,0),"A")In fact you might do the same with Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htmSelect the columns you want to check then use the active cell (ie. in column F) in the following formula =Countif(F:F,"A")0 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Nadine" wrote in message ... Hopefully someone can help me The formula I'm trying to figure out is to be able to count how many jobs a tech can do based on his schedule. Below is listed an example of how techs can be scheduled. Each letter means he can do 2 orders for that time interval. A = am orders, P= pm orders, & E = eve orders. So on day 1 the first tech scheduled AP can do 2am orders and 2pm orders, the second tech can do only 2 pm orders..and so on. I want a formula that based on a range of technicians schedules can say in a cell or cells...that for Day 1...we have the ability to do 2 am orders and 4 pm orders. U##### AP AP P E AE APE AP U1#### P A A AP APE P P i hope this is clear enough |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
counting based on criteria | Excel Worksheet Functions | |||
Counting an Array based on a calculation | Excel Discussion (Misc queries) | |||
counting based on 2 conditions | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |