count the quantity in inventory

[Mark-44]

Hello guys i want to count the quantity in inventory, i have shared a link for my worksheet, please help me to figure out how to do it.


thank you for help
(maybe i'm noob yeah, but pleas help)



https://drive.google.com/open?id=0B0...W9NVjZKVkdyWlk

[Sam Capricci]

this is a bit tricky not having the actual sheet to work with and not knowing any other parameters but this might work...
In inventory C3 =SUMIF('In'!A:A,'Inventory'!A3,'In'!C:C)-SUMIF('Out'!A:A,'Inventory'!A3,'Out'!C:C)

[Mark-44]

@Sambo Kid, thank you so so much
it works

[Sam Capricci]

Great! Glad I could help and thank you for the reputation!