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.