![]() Suppose we have product names in column F and colors in column B of produced sheet. we insert two new columns (Note that we can just create one column, but for better undrestanding we create two), one for count of produced products and the other for sold product.įor counting each product based on name and color, we must use COUNTIFS formula. So in inventory sheet, we have product name and product color columns (and the other optional columns). ![]() So we need count each produced product and also count each sold product Then subtract their values. In your table i suppose the unique identifier for each product is product and color columns combinantion (Note that if you provide a column as ID you can distinguish same products with different colors, but the approach is the same).
0 Comments
Leave a Reply. |