Problems with summation and missing or non acceptable values

In this case, you could do it as outlined in the image shared below:

In the survey tab of your xlsform:

Data entry screen as seen in Enketo:

Reference xlsform:

Aline_issues.xlsx (8.8 KB)