I can obtain the avg of 2 valid, however, on including a 3rd - it jumps to a hudge value.
See these guidelines.
Have you read the documentation? (See also the Calc Guide.)