I'm trying to use the sumproduct formula with an array that looks for a specific value in my cells instead of the entire value of the cell. I need to see if my cells have this specific value somewhere in the cell. But for some reason this isn't working. Can anyone help me figure out what I'm doing wrong?
This is the array that isn't working: --(Table1[Item Desc.]="*PDB*")
This is my entire formula
SUMPRODUCT(--(Table1[Ship Date]>Summary!Q18),--(Table1[Ship Date]<Summary!R18),--(Table1[Facility]=Summary!$U$4),--(Table1[Item Desc.]="*PDB*"),(Table1[M2M Invoice Total]))