Not calculating total sum value of items

[Deepak_Kumar2040]

Inventory Report-  For Total Inward: 

=SUMIF('Purchase for Re-sell'!I7:I106,C10,XLOOKUP('Purchase for Re-sell'!B7,'Purchase for Re-sell'!B7:B106,'Purchase for Re-sell'!M7:M106))

Inventory Report-  For Total Outward: 

=SUMIF('Purchase for Re-sell'!I7:I106,C10,XLOOKUP('Purchase for Re-sell'!B11,'Purchase for Re-sell'!B7:B106,'Purchase for Re-sell'!M7:M106))

This formula is not calculating total sum value of items. This is giving total from half part only.  

[#2]

@Deepak_Kumar2040 

If anybody, can correct the error, please do the same. i have attached the file also.

you may directly send this file after correction to my mail id:

kashyap.dee1986@outlook.com

Regards

Deepak Kumar

[#3 · Accepted solution]

@Deepak_Kumar2040 

Perhaps you mean something like

=SUMIFS('Purchase for Re-sell'!$M$7:$M$106,'Purchase for Re-sell'!$I$7:$I$106,$C21,'Purchase for Re-sell'!$B$7:$B$106,E$6)

[#4]

Certainly This!!!!!!
Thank you Very Much Sergei Baklan sir
Thank you once again.....

[#5]

@Deepak_Kumar2040 , you are welcome