avgerage 3 cells

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.)