Interesting data extraction and calculation conundrum

This excel spreadsheet works, as is. But some of the data in the Raw Data worksheet will ultimately be in the form of XXX/XXX, and the sales data will need to be split equally between those two individuals on the Sales Report. The Sales Report will need to show the total of any lines in the raw data associated with them. There will either be only one entry for a person, or one entry plus another XXX/XXX entry. I have added a few lines of data, highlighted in red, denoting what I am talking about.

How can I get this to report correctly on the Sales Report? I assume it will need to use the LEFT or RIGHT function, but I am unsure how to use them in this scenario. The Sales Report works without the dual employee codes... I just need it to account for these lines as well!

I have included a text box in the spreadsheet that should make this easier to understand>>>> Example Sales Report.xls

I am sure the solution is much easier than I am making this out to be. Thanks for your help!!!!

OH one more thing: I cannot use VBA or macros. This will be used on Excel 2008 for Mac.

JMR 2000
BWW 507.07

These entries need to be split, 1/2 going to each person, and added to the numbers represented on the Service Printout for that person.
Example: BWW/JMR would be split into $1000 each between BWW and JMR. JMR's total on the Service Report would equal 2000 + 1000 = 3000


In your explanation I'm unable to understand that what the mean of BWW/JMR = 2000 ???????

can you clarify more that what u actually want ? Write those figures in BWW/JMR column................