Forum Discussion
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
- Matt MickleBronze Contributor
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. :
- scorpsachinCopper Contributor
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.