VBA compile error: sub or function not defined

[zeno]

Hello,

I receive an error code 'compile error' on 'Sum' for the following code:

d=5 (line 311)
    Range("M" & d + 1) = Sum("M2:M" & d) '** Test: this sum must be zero ; Compile error: sub or function not defined (Sum) (line 422)

This seems to be standard code?
The definition of 'd' is made about 100 lines earlier. Is that the problem?

 

[Jonmo1]

Try

Application.Sum(...)

 

[zeno]

Thank you jonmo1, that brings me one step further.
Now I receive '#VALUE!' in the cell though?

 

[Jonmo1]

oops, I missed it..

Application.Sum(Range("M2:M" & d))

Also, it will error if you have #VALUE! Errors somewhere within the range that is being summed.

 

[zeno]

Yes, great, that is working! Thanks so much!