Forum Discussion

Deepak_Kumar2040's avatar
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...
  • SergeiBaklan's avatar
    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)

Resources