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
|