Many thanks for your answers JazzKult and Alf.

I am just trying to automate the process with a macro. Just got there partially as I am able to calculate the totals with two columns, but I am not able to simulate the breakdown per Sales Rep if I include a Third Column. Any other feedback would be really welcome!!