Hi there!
I'm trying to use a cell to show the number of "kits" able to be made by calculating how many of each component there are, summing those up, and showing the number of kits that could be made. It seems like a somewhat simple task, but I am completely stumped so far.
For example, assuming 5 of each Component 1 and 2 are used to make 1 Kit, see the following:
Component 1 Component 2 10 10 Kits Available 2
I am trying to calculate the "Kits Available" in this example. Any ideas?
Bookmarks