User input value 0.17 or 0 to the calculation cell of the count row.

Hi there!

I'm working to make a survey which combines Excel with a program to make a survey (Survey123 for Arcgis).
In my survey i have 6 questions, first, each of this 6 questions has 2 arguments "yes=0.17 is for appling" and "no=0 is for not appling". Next, checking one of these 2 boxes, the value must update to the Count row for the calculation field / survey sheet (see printscreen) with one of the values 0.17 or 0. The yes or no values are defined in Choices sheet. Next in my survey i need to display the weight % of the check answers, using this function ( if(sum( allcounts = 0, "" , count9/sum( allcounts) and here is the problem...i think that the counts are not defined to allow the formula to work.

Please Login or Register  to view this content.

survey.jpg
This is the survey sheet, the field called ( Name ) is gonna be the future database of the survey to add it in a map.

Choices.jpg
The choices sheet.

App.jpg
The interface of the Survey 123

Thank you!