What is Colors[Inventory] referring to here? =SUMIFS(Colors[Inventory],Colors[Colors],"Orange")
Colors[Inventory]
=SUMIFS(Colors[Inventory],Colors[Colors],"Orange")
the Inventory worksheet in the Colors workbook
the named range Colors[Inventory], which does not use Format as Table Feature Table[Column] can be used instead of cell references (C2:C7).
the Inventory column in the Colors table
the Colors worksheet in the Inventory workbook