Need to create SUMIF Array with multple criteria

anctech
anctech used Ask the Experts™
on
DETAILS:

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))}

MY QUESTION:

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?
Comment
Watch Question

Do more with

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

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
=SUMIFS($L$2:$L$999,$D$2:$D$999,"<>SME",$D$2:$D$999,"<>STAPLES",$D$2:$D$999,"<>SAMMONS")

Open in new window

Author

Commented:
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