You're welcome!

Biff

"Jennifer" wrote in message
...
Thanks. That works.

"T. Valko" wrote:

Sumproduct won't work with wildcards in that manner.

Try it this way:

=SUMPRODUCT((E1:E1000<EDATE(TODAY(),-6))*(ISNUMBER(SEARCH(A1,D1:D1000))))

Biff

"Jennifer" wrote in message
...
I have two functions here. The sumproduct function is just adding one
more
set of criteria to look at when counting.

=COUNTIF(D:D,"*"&A1&"*")

=SUMPRODUCT((E1:E1000<EDATE(TODAY(),-6))*(D1:D1000="*"&A1&"*"))

Why does the Countif function work, but when I used it in a Sumproduct
function, it gives me zero? I know there should me more than zero.

Am I doing something wrong here?

Thanks,

Jennifer