BEGIN { sum=0 ; average=0; noPeople=0 } { if ( $3 == "F" ) { print $0 noPeople++ sum += $4 ; } } END { print "Average marks:", sum/noPeople }