Need help in filtering with a SUMIFS formula.

Hello,

I have a SUMIFS formula on the attached sheet when i go to the Material insert sheet, and filter Column A to sort from A to Z the values on the D column no longer match up with the corresponding cells in cells A&B. Is there any way i can link my current formula to sell A and B on the the same row to be able to filter everything?

Current formula is =SUMIFS('Material Log'!$D$2:$D$1048576,'Material Log'!$A$2:$A$1048576,'Material Insert'!$A2,'Material Log'!$B$2:$B$1048576,'Material Insert'!$B2)
Im hopeing theres a way i canlink it to the first two cells on A, and B on the same row.


Thank You for any help, or advice.

Thank you, that worked for me.