Formula is not calculating inventory balance correctly

[bradyman97]

Below I entered my formula and a small part of my table/spreadsheet. My formula is subtracting everything for the day and putting that total in each day. I need it to subtract and change the balance after each entry.


=SUMIFS([Quantity],[Expected Date],"<="&[@[Expected Date]],[Product Name],[@[Product Name]],[Movement],"101")+SUMIFS([Quantity],[Expected Date],"<="&[@[Expected Date]],[Product Name],[@[Product Name]],[Movement],"351")+SUMIFS([Quantity],[Expected Date],"<="&[@[Expected Date]],[Product Name],[@[Product Name]],[Movement],"102")+SUMIFS([Quantity],[Expected Date],"<="&[@[Expected Date]],[Product Name],[@[Product Name]],[Movement],"701")+SUMIFS([Quantity],[Expected Date],"<="&[@[Expected Date]],[Product Name],[@[Product Name]],[Movement],"702")+SUMIFS([Quantity],[Expected Date],"<="&[@[Expected Date]],[Product Name],[@[Product Name]],[Movement],"961")+SUMIFS([Quantity],[Expected Date],"<="&[@[Expected Date]],[Product Name],[@[Product Name]],[Movement],"352")


D13 E13 F13 G13 K13
Expected Date Movement Product Name Qty Balance

8/30/2016 101 141699 109 109
9/1/2016 351 141699 -2 105
9/1/2016 351 141699 -2 105
9/7/2016 351 141699 -1 104
9/12/2016 351 141699 -1 83
9/12/2016 351 141699 -20 83
9/14/2016 351 141699 -2 78
9/14/2016 351 141699 -2 78
9/14/2016 351 141699 -1 78
9/26/2016 351 141699 -1 77

 

[Matt Rogers]

Wow, a formidable formula.
Are you sure?

 

[Joe4]

Cross-posted here: Formula is not calculating inventory balance correctly

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[bradyman97]

I think so. Any ideas

 

[bradyman97]

Formula is not calculating inventory balance correctly