About Average Formula Problem

How to sum all the score, which is select type, and divide to get the average? just like I get (0.5+0.5+0.5) / 3=ā€¦ but I want NA not to be calculated like I have NA, 0.5, 1 I want the formula is (1+0.5) / 2=0.75 . Could someone help me?

Hi, you may refer to this

1 Like