Dec 27 2020 11:01 PM
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.
Dec 27 2020 11:12 PM
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:
Regards
Deepak Kumar
Dec 28 2020 01:17 AM
SolutionPerhaps 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)
Dec 28 2020 01:56 AM
Dec 28 2020 03:08 AM
@Deepak_Kumar2040 , you are welcome
Dec 28 2020 01:17 AM
SolutionPerhaps 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)