How to SUM my Index(Match) result

[babettedv]

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?

If I add the SUM() function before it doesnt work!

Please help

Thanks a lot!

 

[babettedv]

Yes... But no helpful answer yet so I was hoping you could help out again!

 

[Fluff]

Please be patient.