A case when it happens is when the SUM function is overridden. Check the Name Manager for the SUM name definition:
Remove the definition if available or change its name.
Also, the function can be (?) overridden as UDF. Check VBA code if available.