Say the sum of ranges A1:A10 is 100, why would =SUM(A1:A10*2) resolve to 200 instead of throwing an error?
I looked at the documentation and it says:
The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.
There is no mention of being able to handle multiplication (or anything other than addition). Am I missing something?