I have been using excel for awhile but i have a formula that I know can be created but i cant figure it out. I have 6 groups of data i am working with. Each group has 2 sets of number. The amount of an item that i need and how much i have. I want to create a formula that divides the amount of an item by how much i have across all 6 groups. If the item i am working on needs something from all 6 groups it will tell me if i can make the item for all of it. I didn't explain well so let me put an example down
Item 1 Item 2 Item 3
Item Need/Have Need/Have Need/Have Max number produced
Product 2 10 8 16 5 0 0


If anyone can help me with the formula i need for the max number produced with up to 6 sets of data i would apprieciate it