Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The article you are trying to access is permanently deleted.
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