I got a formula to count shifts worked in daytime=D, evening=E and for night
shift=N.( D,E,N are in each cell per day of the week per worker)
My formula is :
=SUM(COUNTIF(A1:E1,{"D""E""N"})).
Now I have workers doing double shift, that is either DE, EN or ND.
How can I adjust this formula or use another one ( welcome all sugestions)
in order to count D,E,N as 1 item and DE,EN,ND as 2 items or 2 shifts ?
In excel languaje :
A B C D E

D E N
1 D E D N N 2 1 2

2 D DE DE DE EN 4 4 1

Don't need, don't want macros. Thanks a lot in advance.