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.