Sum of columns with nullvalue

[#1]

Hello,

I've a problem with correct sum of column.

I would like sum A+B+C+D

A     B    C     D     E(A+B+C+D)

1     -      2     1     0     wrong value

1     2     3     1     7

1     0     2     3     7

2     -     4      1     0     wrong value

where fields value = NULL the equal  = 0

[CELAMBARASAN · Accepted solution]

Hi,

     Use the rangesum function to solve this problem

     =RangeSum(A,B,C,D)

Celambarasan