Forum Discussion

scorpsachin's avatar
scorpsachin
Copper Contributor
Jul 06, 2018

formula for sumif

Hi I need help to put simple formula but I am not getting it right. 

i have 4 columns with Initial stock, stock in , stock out and final stock. 

which formula shall i use to get correct figure for final stock .  for example if my initial stock is 100 unit and stock in 10 = final stock would be 110. if stock out 20 which makes 90. 

which i have done with + and - formula and works well for only first line . but not the next rows.

 

TIA

Excel Online
Formulas & Functions
  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Jul 06, 2018

    Hope all is well!  You can use the below formula to accomplish what you want.  You just need to fill the formula down using the fill handle in the bottom right corner of the cell.  I'm also attaching an example file for your reference. :

     

     

     

    • scorpsachin's avatar
      scorpsachin
      Copper Contributor
      Jul 09, 2018

      Hi Matt 

      Thanks for your reply. Actually i tried this formula before i put the post but not working for next line. 

       In attached pic , let say for line 3 i stocked out 5 items . now again if i want to sock out same number it doesn't reflect on final stock . OR if i want to stock IN two times same number it does same.

       

      i think it should clear the last number i put in H3 or G3.

       

       

      Thanks in advance again.

Resources