BEGIN { FS = ";" } $3 == "" || $3 == "NA" { missing++; next } { sum += $3; n++ } END { if (n) printf "mean %.2f\n", sum / n else print "no observations" print "observed", n + 0, "missing", missing + 0 }