Need to create SUMIF Array with multple criteria

anctech used Ask the Experts™

Column (D) has single word vendor Names
Column's  (F through K) are types of purchase orders such as printing, medical, office supply, etc. and these cells have purchase order totals as dollar values

I am currently using the following formula to get a sum of purchase order totals for the Vendor name SME    {=SUM(IF(D4:D999="SME",F4:K999))}


How can I make a formula that will total purchase orders totals in cells F4:K999 that DO NOT MATCH three vendor names SME, STAPLES, SAMMONS?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

It would be quite easy if you can create a new column that is the sum of columns F through K such as column L.  This would work in that case

Open in new window


Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial