Thank you so much, this worked beautifully.
--
CK


"Jacob Skaria" wrote:

Try

=SUMPRODUCT(--(ISERROR(SEARCH("*Accural*",Transactions!$C$1:$C$6 5000))=FALSE),--(Transactions!$C$1:$C$65000<""),Transactions!$L$1 :$L$65000)

If this post helps click Yes
---------------
Jacob Skaria


"ColleenK" wrote:

Can you use wildcards and a text string with the sumproduct statement, for
example I would like to find the word "accural" in a string and base the
sumproduct on that, here is my example;

=SUMPRODUCT(--(Transactions!$C$1:$C$65000="*Accural*"),--(Transactions!$C$1:$C$65000<""),(Transactions!$L$ 1:$L$65000))

This example does not work.
--
CK