I have issues to sum my columns. The yellow column should be the sum of the column before.
I tried this formula on the sheet =column1+column2+column3.... but I get this weird result.
I also tried =Sum(column1+column2+column3..) but than the result is shows always 0.0 which is also wrong.
All columns has Text/number format.
I use this e.g. this formula in the purple column to get the numbers and similar once in the other columns
=IF(AND(Helper@row = "BU ", [ Article]@row = "NC"), "1", IF(AND([ Department]@row = "BU ", [ Article]@row = "NC"), "1,5"))
Any idea to solve it?