View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FC FC is offline
external usenet poster
 
Posts: 130
Default 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