Calculating the sum

Hi @Kal_Lam I don’t know how to sum all of the amount in my form. How could this be possible? I want to get the total sum of the amount entered in my row 4 to row 8 in the excel form. Please help. Thank you.

aWF74VQSwYufE6JkvsNkyE (1).xlsx (9.9 KB)

You could do the same as outlined in the image shared below:

In the survey tab of your xlsform:

Data entry screen as seen in Enketo:

Reference xlsform:

Sum.xlsx (8.9 KB)

1 Like

Wow. It worked. Thank you @Kal_Lam . Such a great help.

1 Like

Hi @jollie_slpnpmo
We do have various articles that address most issues around form design within our support articles. I believe this one would have also helped you.

In cases where the support article does not solve your issue, you can run a search on this forum to see if you issue had been previously addressed within the forum. An example of such discussions can be seen below

All the best and wishing you a wonderful experience navigating through our support articles and forum topics.

Stephane

1 Like