I'm glad you were able to get some assistance. If Sunny's reply fully answered your question, please take a moment to mark his post as the Correct Answer. This changes the thread category from Unanswered Question to Answered Question and awards points to Sunny for helping you.
In addition to the preceding, RangSum() will always return a value because invalid values (like text or NULL values) will all be treated as 0. That's the main and very useful difference with the + operator which fill return NULL as soon as even one operand proves to be invalid or NULL.