Prob in Rangesum !!

[nikhilgarg]

HEy,

In following Range function , if we use any numeric value like in first case then will it olways give sum??

And also in second case if we use character with numeric , will it olways give number ??

	rangesum (1,2,4)	returns 7
	rangesum (1,'xyz')	returns 1

[anbu1984]

rangesum (1,'1xyz') returns 1

[saumyashah90 · Accepted solution]

When you use RangeSum()

It treats all Non Numeric values as 0.

So rangesum(1,'xyz') = rangesum(1,0) both will return 1

[nikhilgarg]

HEy,

Thanks