AdamH61686
New Member
Hello,
for my payroll system I have guys working at different jobs and different rates. Sometimes the rates for a particular job is the same as another. In this case I would like the hours at these rates to be combined.
In the picture above, I have an example of what I'm working with, I've formatted the cells in column E to turn yellow when the rates are the same as any other in the section. What I would like is for the corresponding cells in column H to add together. so in this example I'd like cell H8 to read 4 and the others to read 0. I've tried a SWITCH function but can't seem to figure it out.
THANKS!
for my payroll system I have guys working at different jobs and different rates. Sometimes the rates for a particular job is the same as another. In this case I would like the hours at these rates to be combined.
In the picture above, I have an example of what I'm working with, I've formatted the cells in column E to turn yellow when the rates are the same as any other in the section. What I would like is for the corresponding cells in column H to add together. so in this example I'd like cell H8 to read 4 and the others to read 0. I've tried a SWITCH function but can't seem to figure it out.
THANKS!