sum issues

HI Experts,

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?

Thanks

Best Answers

Answers