Sumifs function with 6 criteria including blank

[londoneye001]

Hey Mr. Excel,

i could do with a bit of help here. I got 6 criteria for different product grade in total and some of the criteria fields are blank because we don't have a particular grade for those products. Obviously, i opted in for SUMIFS function but it turned out sumifs cannot handle blank critera, so at the moment I got the formula working using huge if and vlookup function but i believe there must be alternate simpler solution. Can you please help?

My data set is in this format and I pull values from a different tab and each months my columns for the data set is different.

These are my criteria:

A B C D E F

Off Grade	A	AA	AAA	Prime	Other
51523		54523	55523
		54524	55524
		54431	55431
		54338	55338	52338
		54438	55438
	53212	54411	55411

<colgroup><col><col span="5"></colgroup><tbody>
</tbody>

My dataset on a different tab is follows and based on the product # criteria I pull qty in a different column and weight in a different column. Again this dataset is on a seperate tab that I call "DataDump"

Product#	"PLU	Description	Qty	Weight
53212	1570000	BEEF LIVER	18	408.74
54431	541000	BNLS BEEF FLANK	3	77.73

<colgroup><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>

Thanks for your help.

 

[hohlick]

You are welcome!