Sumproduct Help - Referencing Text String

Good Day,

I am having issues with a sumproduct formula referencing a text string parced out from a pivot table.

SUMPRODUCT(--('Invoice Detail'!$V$5:$V$913=LEFT(B75,FIND("Total",B75)-1))*--('Invoice Detail'!$H$5:$H$913>60)*--('Invoice Detail'!$H$5:$H$913<=90),('Invoice Detail'!$S$5:$S$913))-(SUM($M$6:$M74)-SUM($M$6:$M74))

The highlighted is the part of the code that I know is the issue. In this case the value of B75 is "GLOBAL SHARED SERVICES Total". My other spreadsheet references only "GLOBAL SHARED SERVICES". I've tried parcing out the phrase in another column and referencing that cell, but that does not work either. Can someone please advise?