sumproduct with a search and wild card

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"))

You might be able to use ISNUMBER(SEARCH("SWAP",G113:G117)

"Scorpvin" wrote:

>
> 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"))
>
>
> --
> Scorpvin
> ------------------------------------------------------------------------
> Scorpvin's Profile: http://www.excelforum.com/member.php...o&userid=27678
> View this thread: http://www.excelforum.com/showthread...hreadid=551896
>
>