hello i need help to count comma separated values by cell in multiple cells e.g first cell has 14,0,4 second cell has 4,2,0 etc. the first value in the cells need to be added up i.e 14+4 =18 and displayed in a cell named regular hours the second values need to be added up and displayed in another cell called O.T single=0+2=2 and the third values need to be added up and displayed in another cell called O.T 1/2=4+0=4
Solved by E. W. in 12 mins