RANGESUM() function ?

[#1]

Bonjour ;

What is the Result of :

RANGESUM(1, 2, 'abc', NULL(), 5)

[MK_QSL · Accepted solution]

8

RangeSum will add all numeric value and all non-numeric will be considered as 0

[senpradip007]

8 would be the answer

[jvishnuram]

Result is 8

[#5]

Helpful

[#6]

Hi,

Rangesum will treat all non-numeric values as 0.

rangesum (1,2,4)	returns 7
rangesum (1,'xyz')	returns 1
rangesum (null( ))	returns 0
rangesum (above(count(x),-1,3))	returns the sum of the three results of the count(x) function evaluated on the row below the current row, the current row and the row above the current row.