Hi there,
You guys very kindly helped me with a spreadsheet last week.
The current spreadsheets add up each persons totals by matching the name in each tab with the name of the person who won the job located in service orders tab.
BUT.....If two salesman pair up on up on a job then the formula doesn't recognize the joint name. eg Scott/Ash in row 21 & 22 (Service orders).
I need the totals to half the job and add it to the salesmans total accordingly.
You helped me before and i have tried to adapt a formula you wrote.....
Please can someone get the above code working. I have attached the spreadsheet.Please Login or Register to view this content.
Thanks
Sam
Bookmarks