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
|