CRM44862321

I'm trying to calculate the average of 11 rows of radio buttons with 6 columns, excluding any row containing a zero value.  The average calculation does not seem to be accurate, as it calculates all rows, even if the row has zero value.  The radio button rows are named Radio Button 1, Radio Button 2 and so forth.  Radio Button 1, column 1, has a value of 1 and on down the line to Radio Button 1, column 5, which has a value of 5.  Radio Button 1, column 6, has a value of zero.  Each column repeats this format.

How do I get them to average without counting the row with a zero value?