Need help with a sumproduct formula

I assume you're using Excel 2007 or later, in which case:

Formula:

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