LinkBack URL
About LinkBacks
I was wondering how can i go about calculating my inventory. I made an example sheet if someone could take a quick look and let me know if it can be done that would be great.
I was wondering how can i go about calculating my inventory. I made an example sheet if someone could take a quick look and let me know if it can be done that would be great.
Hi,
Paste the below mentioned formula in cell "F3" on the sheet "material".
=(SUMIF('inventory in'!$B:$B,material!$B3,'inventory in'!$D:$D)+SUMIF($B:$B,$B3,$E:$E)) -SUMIF('inventory out'!$B:$B,material!$B3,'inventory out'!$D:$D)
Then you can drag this formula in further rows.
Let me know if it works for you!
Rgds, Kaushal
New Delhi, India
Last edited by im_kaushal; 01-24-2012 at 08:33 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks