I don't believe you can use wildcards in Sumproduct, But there are ways
around that if you can give an example of where you would llke to use the
wildcard.

"Reed" wrote:

I am trying to use SUMPRODUCT to give me the count of the criteria in one
column based on the contents in another column. I have tried to use "*" to
represent "text" and I can not get valid results. I am wondering if
SUMPRODUCT will allow for wildcards or if maybe I need to use a different
function.