Formula Does Not Omit Criteria

J

Joe Gieder

First off thank you for looking at this formula and Happy Holidays to all.
I have this formula Array entered:
=SUM(IF('Priced BOM'!$H$3:$H$458<>"Yes",IF('Priced
BOM'!$N$3:$N$458<>"Purchase*",IF('Priced BOM'!$X$3:$X$458<>"USAInfo",'Priced
BOM'!$AE$3:$AE$458,0

I want to exclude everything in cells N3:N458 that includes the word
"purchase". In cells N3:N458 there are different phrases like "Purchase
History, PO #....", "USAInfo", "Use..." and many others and what I want to do
is have the formula calculate everything except those cells that start with
the word "Purchase". I have used an asterisk after purchase and have tried
the formula with =SUM(IF('Priced BOM'!$H$3:$H$458<>"Yes",IF(LEFT('Priced
BOM'!$N$3:$N$458<>"Purchase",8, nad it doesn't seem to work. Does any one
have any ideas.

TIA
Joe
 
F

Frank Kabel

Hi
try
=SUM(IF('Priced BOM'!$H$3:$H$458<>"Yes",IF(LEFT('Priced
BOM'!$N$3:$N$458,8)<>"Purchase",......
 
J

Joe Gieder

Thank you. It works great. When there's someone else looking they can usually
find the problem.

Again thank you
Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top