keep an individual running total on a large number of different items

[SteveBoz]

Newbie needing help!!!

I am trying to create a basic spread sheet with an inventory. What i would like to do is be able to keep an idividual running total on a large number of different items.


so when i remove 1 of item1 say it adjusts the original total.

The problem i have is as follows.

=Sum(A1-A2) =A3


A2 and A1 stay i place!? so next time i remove 1 it is not a real running inventory as im basicly re-typing everytime. I would really like to just enter a number into A2 with A1 adjusting itself according to the value of A2.

Is this possible or am i talking jibberish!?????

[ChemistB]

Hi Steve,

I'm not sure exactly what you have in cells A1, A2 and A3 in your example

Do you want the present inventory in A1, then enter a value in A2 representing how many you're removing or adding to the inventory and then you want A1 to update? That would require VBA but is possible. Or do you want something more complex?

ChemistB

[psumvp]

You can do this one of two ways...

You could list all of your items in the first column of a new sheet, then use a SUMIF(Data!A:A,a1,Data!B:B)
This will sum all entries in column B that have matches in column A

OR what you are likely looking for is a simple pivot table. This would allow you to alter the data however you want, and then a refresh data on the pivot table will update all values for you.