Using a formula numeric field to find an average score of several questions but want to exclude questions that are N/A

I have a formula numeric field [score] that is assigning a value to checkboxes ( [meets], [partial meets], and [does not meet] ) and then calculating the average of those assigned values. I want to be...