Hi Matthew and welcome to the forum,

Perhaps

=COUNTIF(I16:I33, "*Y*") + COUNTIF(I16:I33, "*A*")/2