Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi to everyone can you please explain me .......... what is the range of sum function ?
Are you intending to ask for RangeSum() function??? If yes than you might find these link to be useful
Calculating rolling n-period totals, averages or other aggregations
Best,
Sunny
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.
I did not know that.
Good to know that as well. Thanks Gysbert Wassenaar