Sum if null

[realpixel]

Hello,

I have the following chart, I add expression

=(DELTA1 + DELTA2 + DELTA3 )

It's works fine if DELTA3 is not null.

The result of the first line should give:

14 + 0 + '-' = 14

Someone have an idea?

DELTA1	DELTA2	DELTA3	DELTA1+DELTA2+DELTA3
14	0	-	-
14	0	-	-
6	0	-	-
6	0	-	-
8	0	-	-
1	0	-	-
9	0	-	-
9	0	-	-
11	0	-	-
9	0	-	-
6	0	-	-
6	0	-	-
6	0	-	-
6	0	-	-
6	0	-	-
6	0	-	-
6	0	-	-
6	0	-	-
33	0	-	-
41	0	0	41
13	0	-	-

[Anonymous · Accepted solution]

Hi,

try you this:

(DELTA1 + DELTA2 + if(isnull(DELTA3),0,DELTA3) )

[tresesco]

Try like:

=RangeSum(DELTA1, DELTA2, DELTA3)

[Aurelien_Martinez]

Hi,

(DELTA1 + DELTA2 + alt(DELTA3, 0))

Best,

Aurélien