trafficzombie
Board Regular
- Joined
- Sep 9, 2011
- Messages
- 63
hi all
I have a spreadsheet that has multiple tabs each tab represents either stock in or out.
The issue I am having is I need to work out the total stock levels value, but some of the stock will be the same item but different values.
How do I add these together using formulas when there could be multiple lines of the same item with a different value and a different stock level?
I posted this earlier but got no replies:
I really would appreciate some help
I have a spreadsheet that has multiple tabs each tab represents either stock in or out.
The issue I am having is I need to work out the total stock levels value, but some of the stock will be the same item but different values.
How do I add these together using formulas when there could be multiple lines of the same item with a different value and a different stock level?
I posted this earlier but got no replies:
Calculating Sums over two tabs
Hi all I hope someone can help, I am getting so confused trying to work this out. I have a spreadsheet for a customer to keep track of stock in and out and they have asked me to add a section to show them the total value of the stock. One the first tab below it shows a code number which links...
www.mrexcel.com
I really would appreciate some help