Forum Discussion

Deepak_Kumar2040

Copper Contributor

Dec 28, 2020

Solved

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...

NEW MIS .xlsx467 KB

Formulas and Functions

SergeiBaklan

Dec 28, 2020

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)

NEW MIS .xlsx467 KB

Deepak_Kumar2040

Copper Contributor

Dec 28, 2020

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

SergeiBaklan

Diamond Contributor

Dec 28, 2020

Deepak_Kumar2040 , you are welcome