Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |