SUMPRODUCT But With <> Criteria
I'm using this formula but I get the wrong answer,
=SUMPRODUCT(--('Priced BOM'!$H$3:$H$458<"Yes"),--(LEFT('Priced
BOM'!$N$3:$N$458,8)<"Purchase"),--('Priced
BOM'!$X$3:$X$458<"USAInfo"),--(ISNUMBER(SEARCH("Estimate",'Priced
BOM'!$X$3:$X$458))),('Priced BOM'!$AE$3:$AE$458))
What I want to do is where the formula says
--(ISNUMBER(SEARCH("Estimate",'Priced BOM'!$X$3:$X$458)))
what I realy would like to do is not include the cells that contain the word
"Estimate" But I can't figure it out. One thing the word "Estimate" can
either be in the front, middle or end of the string.
Thanks For Your Help
Joe
|