How to add value of a conditioned cell to the value of another?

Question

How to add value of a conditioned cell to the value of another?

Navigation

#1 by (3 votes)

2

I'm trying to do this sum in excel. I have the products with prices and the kits of which they participate, but I do not know how to calculate the total value for each kit automatically.
I would like to be able to include and take the products of the kits and also change the price of each product and the kits will update automatically. Is it possible?

excel

asked by anonymous 28.07.2016 / 15:12

1 answer

Is there an insertion method for a binary search tree that is faster than the trivial one? How to make communication between java in prolog?

score 3 · Accepted Answer

Instead of specifying each kit that makes up the product in column B, divide this column into 3: Kit 1, Kit 2 and Kit 3, for example for product1, mark an "X" in the columns corresponding to the kits 1, 2, and 3 and make a conditional formula for it to add up only if those cells have the "X".