Link to home
Start Free TrialLog in
Avatar of Lawrence Salvucci
Lawrence SalvucciFlag for United States of America

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),--(Table1[Ship Date]<Summary!R18),--(Table1[Facility]=Summary!$U$4),--(Table1[Item Desc.]="*PDB*"),(Table1[M2M Invoice Total]))
SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Lawrence Salvucci

ASKER

Thank you both for your help. I wasn't aware that you couldn't use the wildcard with SUMPRODUCT. I went with the SUMIFS solution and it works perfectly.