INDEX, MATCH Help

[Kcroft9]

Hi,

im currently using the following formula to INDEX and MATCH a couple of Criterea which I thought was working perfectly until I noticed a discrepancy with the Outputs vs Actuals. the below formula is only returning a 1 line value. for example the cell AQ2 in the formula is the date im looking for in QueryReport!$J$2:$J$50000 and B64 is a process. if there is 2 entries in my dataset for the same date and same process, say 10 on each line, the formula only returns 10, where I require it to sum these and return 20.

=IFERROR(INDEX(QueryReport!$A$2:$J$50000,MATCH(1,(QueryReport!$A$2:$A$50000=$B64)*(QueryReport!$C$2:$C$50000=$A$40)*(QueryReport!$J$2:$J$50000=AQ$2),0),4),0)

My formula itself is good and matchs as I want, but im 99% sure I need to add the SUMPRODUCT function to the formula in order to get the outcome I described above. I just cant seem to fit it in anywhere to work,

Any ideas?

Thanks in advance,

[TMS]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[jason.b75]

Without a sample I'm seeing

=SUMIFS(QueryReport!D:D,QueryReport!A:A,B64,QueryReport!C:C,A$40,QueryReport!J:J,AQ$2)