Query related to formula

Super Contributor

Hello Everyone, 


I want to check the left over stock for the specific fruit name's Serial number. So example, at the start I have 5 Apples of serial number 123,     2 Apples check out which left 3 Apples left, but a new stock of oranges came in for example, 1 Apple of serial number 123, therefore my current available stock for Apples would be 4.


Please help..


Here is a attached file..

1 Reply
best response confirmed by Zain123 (Super Contributor)



So what you need is to add check-in fruits with existing stock then minus checkout quantities. You have to use SUMIFS() function. Try below formula-