Instead of #Missing, could the word translate as #Value.  If so, then check the data type of values such as trying to sum Strings and numbers.