Hi All,
I have an INDEX & MATCH looking up values, and retrieving a "-" in case of an error or in case of a zero. I am looking to SUM all values in the "2021" column with the A407 criteria. Can't seem to get it working with adding the SUM before the INDEX in the formula. 




	



















	
=IFERROR(IF(INDEX('Inventory'!$1:$999999,MATCH($A407,'Inventory'!$A$1:$A$999999,0),MATCH("2021",'Inventory'!$1:$1,0))=0,"-",INDEX('Inventory'!$1:$999999,MATCH($A407,'Inventory'!$A$1:$A$999999,0),MATCH("2021",'Inventory'!$1:$1,0))),"-")
Any help would be wonderful!

Thanks,