Excel - Stock tracking?

Soldato
Joined
6 Jun 2011
Posts
2,741
Hey guys,

So as the title says, I have Excel 2010 and basically have different items which I am trying to keep track of stock.

The best way I could think of was to have the initial total amounts for each item in seperate cells and then search down the column of sold items to find matching item names and -1 off of the corresponding item total. Not really sure how to do this though, or even if this is the best way.

Any help appreciated,

Cheers :)
 
=COUNTIF(A1:A100,"Test Item")

Something like that?

Or

=C1-COUNTIF(A1:A100,"Test Item")

To display remaing stock, if C1 held your initial total.
 
Last edited:
Back
Top Bottom