2
I’m trying to do this sum in excel. I have the products with prices and kits that they participate in, but I don’t know how to calculate the total value for each kit automatically.
I would like to be able to include and remove the products from the kits and also change the price of each product and the kits to be updated automatically. It is possible?
3
Instead of specifying each kit that composes the product in column B, divide this column into 3: Kit 1, Kit 2 and Kit 3, so for example for product 1, mark an "X" in the columns corresponding to kits 1, 2 and 3 and make a conditional formula for it to add only if such cells have the "X".
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.
Thank you very much. Easier than I imagined. I was trying much harder things than that. So I couldn’t do it. Problem solved. Hug.
– Marcio