Hello,

I'm creating a spreadsheet that tracks inventory required of products in a kit. Our kit consists of a parent product that has 3 child products. These child products can also be a part of additional parent products.

Here is what a kit with 3 child products looks like in a board:

Arbor 31" Longboard Deck, Arbor Bogart 61mm 82a Red Wheels, Caliber Standard 8.5" Raw Trucks

After creating a list of these kits, we have a column for adding up duplicate products, using COUNTIF(E:E,E2)

This has been working great to determine how many of these child products we need in inventory to build 1 of each board.

What we would love some help with is to determine how many of these child products we need in inventory to build 1 or more of each board. Example:

Qty 2, Arbor 31" Longboard Deck, Arbor Bogart 61mm 82a Red Wheels, Caliber Standard 8.5" Raw Trucks
Qty 4, Arbor 32" Longboard Deck, Arbor Bogart 61mm 82a Red Wheels, Caliber Standard 8.5" Raw Trucks
Qty 1, Arbor 33" Longboard Deck, Arbor Bogart 61mm 82a Red Wheels, Caliber Standard 8.5" Raw Trucks

The answers should be:
Arbor Bogart 61mm 82a Red Wheels, need an inventory level of 21
Caliber Standard 8.5" Raw Trucks, need an inventory level of 21

I hope this makes sense. I'm just learning this today. Again, here is the current formula: COUNTIF(E:E,E2)

Thanks.