HOW DO I ADD VALUES IN A ROW

F

FC

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.
 
T

Toppers

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top