Can anyone help me with the formula, how I summarize plus and negative numbers in different columns, negative numbers to column marked with red. see attached file.

I would also remove the characters that In market with a blue box in the attached file, if this is possible without changing the mathematical formula in the 50 lines?