SOLVED

# Not calculating total sum value of items

Occasional Contributor

# Not calculating total sum value of items

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.

4 Replies

# Re: Not calculating total sum value of items

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

best response confirmed by Deepak_Kumar2040 (Occasional Contributor)
Solution

# Re: Not calculating total sum value of items

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)``

# Re: Not calculating total sum value of items

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

# Re: Not calculating total sum value of items

@Deepak_Kumar2040 , you are welcome