Try something like this:

To count the D, E, and N shifts in A1:E1:
F1: =SUM(COUNTIF($A1:$E1,"*"&{"D","E","N"}&"*"))

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"FC" wrote in message ...
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.