I want the current formula to sum everything that does not have *U.S. Treasury* in it. I need the SEARCH function in it to search for the alpha characters.


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