| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
RECREATING THE PROBLEM !!!!!!!
I HAVE A LIST OF EMPLEYEES THAT WORK 3 SHIFTS: D,E,N FOR DAYS, EVENINGS AND
NIGHTS RESPECTIVELY. ALL 40 EMPLOYEES ROTATE SHIFT PER WEEK AND IS VERY RAMDOM THE SHIFT THEY WORK. NOW, I HAVE ALL THEIR NAMES IN A SHEET THAT I SCHEDULE THEM. AT THE END I HAVE 3 ROWS WITH FORMULAS FOR D,E,N TO GIVE ME THE TOTAL AMOUNT OF EMPLOYEES WORKING EACH SHIFT. THE FORMULA IS =COUNTIF(A1:A40,"D") FOR COUNTING THE EMPLOYES WORKING DAYS, ANOTHER FOR E AND LAST ONE FOR N. IT WORKS PERFECTLY, BUT WHEN I HAVE EMPLOYES WORKING DOUBLE SHIFT ( D/E) OR EVENING/NIGHTS E/N, I HAVE NO WAY TO COUNT THESE SHIFTS INDIVIDUALLY SO THEY CAN SHOW IN THE APPROPIATE CELL. THE WORKSHEET HAVE 40 COLUMNS AND 30 ROWS ( EACH DAY OF THE MONTH).Q IS THERE A BETTER FORMULA TO COUNT HOW MANY D,E,N PER DAY AND INCLUYE D/E , E/N AND N/D.TX |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RECREATING THE PROBLEM !!!!!!!
Maybe there's a better way, but my two cents a
=countif(a1:a40,"D")+countif(a1:a40,"D/E")+countif(a1:a40,"N/D") Regards Esteban "FC" wrote: I HAVE A LIST OF EMPLEYEES THAT WORK 3 SHIFTS: D,E,N FOR DAYS, EVENINGS AND NIGHTS RESPECTIVELY. ALL 40 EMPLOYEES ROTATE SHIFT PER WEEK AND IS VERY RAMDOM THE SHIFT THEY WORK. NOW, I HAVE ALL THEIR NAMES IN A SHEET THAT I SCHEDULE THEM. AT THE END I HAVE 3 ROWS WITH FORMULAS FOR D,E,N TO GIVE ME THE TOTAL AMOUNT OF EMPLOYEES WORKING EACH SHIFT. THE FORMULA IS =COUNTIF(A1:A40,"D") FOR COUNTING THE EMPLOYES WORKING DAYS, ANOTHER FOR E AND LAST ONE FOR N. IT WORKS PERFECTLY, BUT WHEN I HAVE EMPLOYES WORKING DOUBLE SHIFT ( D/E) OR EVENING/NIGHTS E/N, I HAVE NO WAY TO COUNT THESE SHIFTS INDIVIDUALLY SO THEY CAN SHOW IN THE APPROPIATE CELL. THE WORKSHEET HAVE 40 COLUMNS AND 30 ROWS ( EACH DAY OF THE MONTH).Q IS THERE A BETTER FORMULA TO COUNT HOW MANY D,E,N PER DAY AND INCLUYE D/E , E/N AND N/D.TX |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RECREATING THE PROBLEM !!!!!!!
There is not better way, this is it, thanks a lot Esteban
"Esteban" wrote: Maybe there's a better way, but my two cents a =countif(a1:a40,"D")+countif(a1:a40,"D/E")+countif(a1:a40,"N/D") Regards Esteban "FC" wrote: I HAVE A LIST OF EMPLEYEES THAT WORK 3 SHIFTS: D,E,N FOR DAYS, EVENINGS AND NIGHTS RESPECTIVELY. ALL 40 EMPLOYEES ROTATE SHIFT PER WEEK AND IS VERY RAMDOM THE SHIFT THEY WORK. NOW, I HAVE ALL THEIR NAMES IN A SHEET THAT I SCHEDULE THEM. AT THE END I HAVE 3 ROWS WITH FORMULAS FOR D,E,N TO GIVE ME THE TOTAL AMOUNT OF EMPLOYEES WORKING EACH SHIFT. THE FORMULA IS =COUNTIF(A1:A40,"D") FOR COUNTING THE EMPLOYES WORKING DAYS, ANOTHER FOR E AND LAST ONE FOR N. IT WORKS PERFECTLY, BUT WHEN I HAVE EMPLOYES WORKING DOUBLE SHIFT ( D/E) OR EVENING/NIGHTS E/N, I HAVE NO WAY TO COUNT THESE SHIFTS INDIVIDUALLY SO THEY CAN SHOW IN THE APPROPIATE CELL. THE WORKSHEET HAVE 40 COLUMNS AND 30 ROWS ( EACH DAY OF THE MONTH).Q IS THERE A BETTER FORMULA TO COUNT HOW MANY D,E,N PER DAY AND INCLUYE D/E , E/N AND N/D.TX |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RECREATING THE PROBLEM !!!!!!!
This might be easier to modify if you need to add more strings:
=sum(countif(a1:a40,{"D","D/E","N/D"})) FC wrote: There is not better way, this is it, thanks a lot Esteban "Esteban" wrote: Maybe there's a better way, but my two cents a =countif(a1:a40,"D")+countif(a1:a40,"D/E")+countif(a1:a40,"N/D") Regards Esteban "FC" wrote: I HAVE A LIST OF EMPLEYEES THAT WORK 3 SHIFTS: D,E,N FOR DAYS, EVENINGS AND NIGHTS RESPECTIVELY. ALL 40 EMPLOYEES ROTATE SHIFT PER WEEK AND IS VERY RAMDOM THE SHIFT THEY WORK. NOW, I HAVE ALL THEIR NAMES IN A SHEET THAT I SCHEDULE THEM. AT THE END I HAVE 3 ROWS WITH FORMULAS FOR D,E,N TO GIVE ME THE TOTAL AMOUNT OF EMPLOYEES WORKING EACH SHIFT. THE FORMULA IS =COUNTIF(A1:A40,"D") FOR COUNTING THE EMPLOYES WORKING DAYS, ANOTHER FOR E AND LAST ONE FOR N. IT WORKS PERFECTLY, BUT WHEN I HAVE EMPLOYES WORKING DOUBLE SHIFT ( D/E) OR EVENING/NIGHTS E/N, I HAVE NO WAY TO COUNT THESE SHIFTS INDIVIDUALLY SO THEY CAN SHOW IN THE APPROPIATE CELL. THE WORKSHEET HAVE 40 COLUMNS AND 30 ROWS ( EACH DAY OF THE MONTH).Q IS THERE A BETTER FORMULA TO COUNT HOW MANY D,E,N PER DAY AND INCLUYE D/E , E/N AND N/D.TX -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RECREATING THE PROBLEM !!!!!!!
Thanks a lot Dave, I will use this one too.
"Dave Peterson" wrote: This might be easier to modify if you need to add more strings: =sum(countif(a1:a40,{"D","D/E","N/D"})) FC wrote: There is not better way, this is it, thanks a lot Esteban "Esteban" wrote: Maybe there's a better way, but my two cents a =countif(a1:a40,"D")+countif(a1:a40,"D/E")+countif(a1:a40,"N/D") Regards Esteban "FC" wrote: I HAVE A LIST OF EMPLEYEES THAT WORK 3 SHIFTS: D,E,N FOR DAYS, EVENINGS AND NIGHTS RESPECTIVELY. ALL 40 EMPLOYEES ROTATE SHIFT PER WEEK AND IS VERY RAMDOM THE SHIFT THEY WORK. NOW, I HAVE ALL THEIR NAMES IN A SHEET THAT I SCHEDULE THEM. AT THE END I HAVE 3 ROWS WITH FORMULAS FOR D,E,N TO GIVE ME THE TOTAL AMOUNT OF EMPLOYEES WORKING EACH SHIFT. THE FORMULA IS =COUNTIF(A1:A40,"D") FOR COUNTING THE EMPLOYES WORKING DAYS, ANOTHER FOR E AND LAST ONE FOR N. IT WORKS PERFECTLY, BUT WHEN I HAVE EMPLOYES WORKING DOUBLE SHIFT ( D/E) OR EVENING/NIGHTS E/N, I HAVE NO WAY TO COUNT THESE SHIFTS INDIVIDUALLY SO THEY CAN SHOW IN THE APPROPIATE CELL. THE WORKSHEET HAVE 40 COLUMNS AND 30 ROWS ( EACH DAY OF THE MONTH).Q IS THERE A BETTER FORMULA TO COUNT HOW MANY D,E,N PER DAY AND INCLUYE D/E , E/N AND N/D.TX -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
| How do I change my DSN without recreating the odbc connection? | Excel Worksheet Functions | |||
Linear Mode
