I have the following formula that works just great, but I need to be able to
have "N/A" display if text is entered instead of a number value. Any
Suggestions?

=CHOOSE(SUMPRODUCT(--($A$1:$A$11=E27),--(G27=$B$1:$B$11),$D$1:$D$11)+SUMPRODUCT(--(E27=$A$13:$A$17),--(G27$B$13:$B$17),--(G27<=$C$13:$C$17),$D$13:$D$17),"Inconsistent","Do es Not Meet","Successful","Excellent","Exceptional")