I want to use a SEARCH and wildcard for Swap instead of a LEFT. The text "swap" is not always the first word in the string. I don't know if this matters but the cell that has swap is text formatted.

=SUMPRODUCT(--(N113:N117),--(H113:H117=DATE(2006,3,1)),--(LEFT(G113:G117,3)="Swap"))