I have raw materials that go into several finished goods. I will like a formula where I can input several Raw Materials and I get the count of the finished goods. I think a count if formular will work, but I am not sure.
Ok. Here is more data. column 1 has the Raw Materials and Column 2 has the FG. on the next tab if I enter a Raw Material, I want the next column to give me a count of the FG associated with the Raw Material.