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