Changing an indirect function to "Index / Match"

To do it without Indirect, you'd have to explicitly name the table in the formula
=SUMIF(Table1[Produit],B6,Table1[Prix])

Unless the formula actually resides within the Table, then you don't need to name the table at all
=SUMIF([Produit],B6,[Prix])