Getting sum of different variables

[Kal_Lam]

Welcome back to the community, @Ruvuga! You could add as discussed in our previous post:

How do we use the calculate function in KoBoToolbox to add 2 variables?

Hi @tanzilhuda, You could calculate the average as shown in the image below: In the survey sheet of your xlsform: [image] Reference xlsform: Addition_Average_Calculation.xlsx (9.7 KB)

Note, if there are any blank entries, you could add using the coalesce as discussed in our previous post:

Total score

@TM1997, try as outlined in the image shared below using the coalesce using this expression coalesce(${aa},0)+coalesce(${bb},0)+coalesce(${cc},0)+coalesce(${dd},0)+coalesce(${ee},0)+coalesce(${ff},0)+coalesce(${gg},0)+coalesce(${hh},0)+coalesce(${ii},0): xlsform as seen in the survey tab: [Image 1] Reference xlsform: aNtRgMLhFxYodNtX8bGUDi (2).xlsx (27.3 KB)