Lawrence Salvucci
asked on
Sumproduct in Excel
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),--(Tabl e1[Ship Date]<Summary!R18),--(Tabl e1[Facilit y]=Summary !$U$4),--( Table1[Ite m Desc.]="*PDB*"),(Table1[M2 M Invoice Total]))
This is the array that isn't working: --(Table1[Item Desc.]="*PDB*")
This is my entire formula
SUMPRODUCT(--(Table1[Ship Date]>Summary!Q18),--(Tabl
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER