Adding costs of stock with multiple values

[trafficzombie]

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:

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

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.