SUM INDEX MATCH Help.

[tandkb]

Hi I am currently using this formula.

=IFERROR(INDEX(Transfers!$J$5:$J$999999,MATCH(A68&$A$61,Transfers!$F$5:$F$999999&Transfers!$H$5:$H$999999,0),MATCH($A$3,Transfers!$E$5:$E$999999,0)),0)

It works great except it does not sum multiple matches it only find the first match in the table. I need it to SUM all the matches in the table.

Thanks so much for your help in advance!

 

[tandkb]

To improve sheet performance, you must change 999999 to a smaller number, perhaps a slack of 10 additional rows over the last cell with data.
Having several array formulas does not improve sheet performance.
If the sheet is very slow, then you could change some formulas for macros.

Ah ok. The SUMPRODUCT is not an Array Correct. I will start with that and then replace the 9999999. Thanks so much for the help once again!

 

[DanteAmor]

Ah ok. The SUMPRODUCT is not an Array Correct. I will start with that and then replace the 9999999. Thanks so much for the help once again!

Technically sumproduct itself is an array formula, only that it looks like a regular formula.
For the criteria you are looking for a formula array is necessary.