RECREATING THE PROBLEM !!!!!!!

[Guest]

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

 

[Guest]

Maybe there's a better way, but my two cents are:

=countif(a1:a40,"D")+countif(a1:a40,"D/E")+countif(a1:a40,"N/D")

Regards
Esteban

 

[Guest]

There is not better way, this is it, thanks a lot Esteban

 

[Dave Peterson]

This might be easier to modify if you need to add more strings:

=sum(countif(a1:a40,{"D","D/E","N/D"}))

 

[Guest]

Thanks a lot Dave, I will use this one too.

This might be easier to modify if you need to add more strings:

=sum(countif(a1:a40,{"D","D/E","N/D"}))