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.....
=SUMPRODUCT(--('Service Orders'!$B$2:$B$927=B8),--ISNUMBER(SEARCH(LEFT(D$3,FIND(" ",D$3&" ")-1), 'Service Orders'!$C$2:$C$927))—(('Service Orders'!$I$2:$I$927="Contract"),('Service Orders'!$F$2:$F$927) +1)-LEN(SUBSTITUTE(‘Service Orders'!$C$2:$C$928,"/","")))
Please can someone get the above code working. I have attached the spreadsheet.
Thanks
Sam
Bookmarks