'How to sum cells up in Excel?

I have a enormous excel file, which has information about some ship containers and goods within them. Some of rows are False and I have to zero their value and add them to another row. Let's say:

enter image description here

How to change table on the right to the left?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source