Hi all,
I have build a flexible Index Match formula that finds the cost of certain ingredient (A3) within a certain product (F2), from the recipe sheet (referred to with Indirect so I can change the name of the sheet).
=IFERROR(INDEX(INDIRECT("'"&F$1&"'!$B$8:$Y$45"),MATCH($A3,INDIRECT("'"&F$1&"'!$A$8:$A$59"),0),MATCH(F$2,INDIRECT("'"&F$1&"'!$B$7:$Y$7"),0)),0)
However, the certain ingredient shows up several times in the recipe list so I am looking for a way to SUM the outcomes of my Index Match?
Thanks a lot!
I have build a flexible Index Match formula that finds the cost of certain ingredient (A3) within a certain product (F2), from the recipe sheet (referred to with Indirect so I can change the name of the sheet).
=IFERROR(INDEX(INDIRECT("'"&F$1&"'!$B$8:$Y$45"),MATCH($A3,INDIRECT("'"&F$1&"'!$A$8:$A$59"),0),MATCH(F$2,INDIRECT("'"&F$1&"'!$B$7:$Y$7"),0)),0)
However, the certain ingredient shows up several times in the recipe list so I am looking for a way to SUM the outcomes of my Index Match?
Thanks a lot!