Need help in filtering with a SUMIFS formula.

[Herrerag92]

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.

[dosydos]

simple fix:
change formula so you don't include "'MATERIAL INSERT!" in your main references. It should just be $A2 and $B2 as shown below:

=SUMIFS('Material Log'!$D$2:$D$1048576,'Material Log'!$A$2:$A$1048576,$A2,'Material Log'!$B$2:$B$1048576,$B2)

drag down and then sort all you want.

[Herrerag92]

Thank you, that worked for me.

[dosydos]

glad it worked, and thanks for the Rep