If columns for "D","E" and "N" are G,H and I
then can you not add all three assuming value is zero or blank if not worked?

=Sum(G2:I2)

or if you want only D+N then =G2+I2

Copy/drag down column

HTH

"FC" wrote:

I have a rows with employees names and the shift they work : D, E, N for days
evening and nigths respectively. At the end of the row I have 3 columns with
the total for each shift ( ex. 19 for D, 23 E , 12 N) by using formulas. No
problem. Q: how do I add the cells where employees work 2 shifts like D/E or
E/N. Can they be counted separately and added to the total?Tx in advance.