-1

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?

Nikolay Panev
  • 1

1 Answers1

1

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:

=COUNTIF($G$1:$G$20,A1)
Tom Zych
  • 1,051