I am writing an inventory list for my office, which is combined with a borrow list. What I want to do, is change the number of items in the inventory list, once an item has been borrowed. For instance, if I have 2 hard drives listed on stock, I want the spreadsheet to automatically decrement that value, when I enter that data in the borrow list. Any ideas how can I do that?
It sounds like the
COUNTIF() function would be useful. You can use it
to count how many cells in a range match some value. Say an inventory ID
is in A1, borrowed item IDs are in G1:G20, and you want B1 to say how
many of A1 were borrowed. I don't have Excel on this machine, but
something like this in B1: