Inventory movement convert daily to WEEKLY

[makinmomb]

Have the formula that does the work daily ,
need formula on sheet3 , that does the convert
of daily into weeks ?

[FDibbins]

Hi

before I answer your question, an observation....

What is the purpose of teh *-1 at the end of this?

=(SUMIFS(Sheet2!$H:$H,Sheet2!$E:$E,$A2,Sheet2!$A:$A,C$1)*-1)
If you want to "negative" the answer, just use...
=-SUMIFS(Sheet2!$H:$H,Sheet2!$E:$E,$A2,Sheet2!$A:$A,C$1)
If it is to to convert a text answer to a numeric, then that wont work, as the sumifs() will not add text.

To start of your answer, it woukd really help if you add some dummy data to sheet2, and also include some headings? I would approach this with a helper column in sheet2 with =WEEKNUM(A1), and then base your calcs on that

[makinmomb]

Hi

before I answer your question, an observation....

What is the purpose of teh *-1 at the end of this?

=(SUMIFS(Sheet2!$H:$H,Sheet2!$E:$E,$A2,Sheet2!$A:$A,C$1)*-1)
If you want to "negative" the answer, just use...
=-SUMIFS(Sheet2!$H:$H,Sheet2!$E:$E,$A2,Sheet2!$A:$A,C$1)
If it is to to convert a text answer to a numeric, then that wont work, as the sumifs() will not add text.

To start of your answer, it woukd really help if you add some dummy data to sheet2, and also include some headings? I would approach this with a helper column in sheet2 with =WEEKNUM(A1), and then base your calcs on that

That is 103 rows of raw data , look at sheet1 , its compiling by daily

[makinmomb]

You may need to pull not from the raw data , perhaps from the sheet1 maybe

[FDibbins]

Still did not answer my question as to why you are *-1.

I still suggest that you add a helper column with the =WEEKNUM(), then base the calc off that

[makinmomb]

Our sap system report throws movements into negatives , and returns
into positives , that negative can be avoided , if the raw data is multiplied
by 1 and than copy paste special

[makinmomb]

I mean negative raw data quantity multiply -1 to get positive raw data

[makinmomb]

Go ahead add the helper , lets see how it looks like ?