Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is the range of sum function ?

hi to everyone can you please explain me .......... what is the range of sum function ?

3 Replies
sunny_talwar

Are you intending to ask for RangeSum() function??? If yes than you might find these link to be useful

Accumulative Sums

Calculating rolling n-period totals, averages or other aggregations

Best,

Sunny

Gysbert_Wassenaar

The rangesum function calculates the sum of the values passed to the function. All non-numeric values are treated as 0. That makes it useful if you have to deal with nulls and don't want a null as result. 11 + 2/0  will return null because 2 divided by 0 returns null. But rangesum(11, 2/0) will return 11.


talk is cheap, supply exceeds demand
sunny_talwar

I did not know that.

Good to know that as well. Thanks Gysbert Wassenaar