Forum Discussion
Filter on table and column
Hello, i have two tables, one that has the stock of each product and the second has a cloumn that has the names of the products purchased. each row of this column contain one product purchased, so if...
If that's the case, then you need to apply a countrows for the first sheet where you will be counting the purchases. Then, take the difference of the sum of stocks from the second sheet.
countrows is fine, I did that, my problem is the formula where you change that every time you change the filter, so when i select books in the filter the box showing the available stock should show me the books stock, if i select pens then the box should show me the Pens stock and so on...