Calculate Bundle Products Profit, Cost, ETC Without Individually Calculating Each New Bundle

Hello I am trying to organise and format a product catalouge in calc and need an easier more automated way to calculate bundle product prices, materials costs, profit from single products on the same sheet without doing so individualy everytime, as it will eventually have many more products and materials, ive attached an image of and the file id like help with. Thank you

example sheet.ods (11.5 KB)

What is your question?

Ive found what I was looking for, it was SUMPRODUCT() to calculate the values from single products to bundles.

1 Like