SUMIF with exclusion critera

[Zanith]

I'm using the following SUMIF formula to look at a Named Range, PRODUCTS within a table on a separate sheet titled DATA DUMP and return to me the total QUANTITY produced for that particular product.

=SUMIF(PRODUCTS,A2,QUANTITY)

Occasionally there will be anomalies within the data in the DATA DUMP table and I would like to exclude those entries from the SUMIF above. I've created a new named range within DATA DUMP called EXCLUDE. I would like to wrap the exclusion around the SUMIF formula above making it so that if there is an X entered into the EXCLUDE cell in that product row it would omit it from the calculation and move on to the next but I've been unsuccessful in making this work properly.

Any help would be greatly appreciated!

[Pepe Le Mokko]

Hi
try the SUMIFS function

[thameem127]

Upload your file for workout.