Adding costs of stock with multiple values

Status
Not open for further replies.

trafficzombie

Board Regular
Joined
Sep 9, 2011
Messages
61
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
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,448
Office Version
  1. 365
Platform
  1. Windows
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.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,114,508
Messages
5,548,483
Members
410,839
Latest member
MrSumo85
Top