Splitting a field?

I made a excel file that tracks how many cars we sell. I have it tracking the units sold and each salesperson and how many they sell. So on the 3rd sheet, the sales tracking sheet, when one of the cells in the other 2 sheets see's a name, i.e. "STEVE" or "VERN" or whatever, it adds it.

Now, my question is, if 2 sales people sell the car and I need to split the unit, 1/2's, can that be done? I have a "salesperson" column and a "Split deal" column. Just wonder if this is possible?

Thanks in advance!

the last sheet has the salespeople info. I need the NEW and USED pages to read a "SPLIT sale" which it only reads the "salesperson" as I don't know how to formulate any further.

hope this helps? and thanks!

Ok...I'm trying to mess with this....now, bear with me as I'm a excel 'hack' and figure things out as I go, sometimes

this top formula you helped with will go on the "salestracker" sheet, under the NEW column for each salesperson?

If so, do I put the salesperson name between the ""? And then do I copy and paste, changing "new" to "used" for the used column?

thanks for all the help!

wow! that worked like a charm! Thank you so very much! ever need a car...let me know

Thanks again!!

lol! well, hey, it's the thought that counts

Thanks again and keep in touch!