Need help with a sumproduct formula

You don't need the * wildcards. SEARCH already looks for a substring.

Formula:

=SUMPRODUCT(E3:E782,--(ISERROR(SEARCH("U.S. Treasury",D3:D782))))

which can also be done with SUMIF by using those wildcards:

Formula:

=SUMIF(D4:D782,"<>*U.S. Treasury*",E4:E782)