How to sum cel if condition is true

Hi,

I have a chart with line of products, items by line and validation by line of product.

My idea is that if the validation is true (verdadero) then at the en the value of the cell will get added to those others that have a validation =true, but if any other validation of product line is false (falso) then that value will not be added to the final result.

i just need the formula that will make the addition work bellow an image of the chart, on top you see the validation bello teh product line and to the left the items or products.

chartvalid.JPG




thanks for the help

Try something as:

Formula:

Please Login or Register  to view this content.

Hi Zbor,

the formula is not working

Upload example workbook and write expected result

validation--->	true	true	false
item	prod-line1	prod-line2	prod-line3	total
item1	2	3	4	5
item2	6	7	8	13
item3	5	4	3	9

Every time a column validation is true the value of teh item will be added at the en on the total column in the same way if te validation is false that value will not be added in the total column.

For example in for item1 only the values 2 and 3 are being added because the last validation is false.

So what's problem with above formula?

ok,

restarted the pc and it worked perfectly.

Thanks

it works because the true=1 and the false=0 right?

Yes, with other words it wouldn't work (all other words are like false, only true is true).