Hi All, Am doing a project which requires to calculate number of caregivers in a home(this is a loop). Based on the number of children under each care givers I will need to do another loop for the children under each caregiver. Is it possible to have 2 separate loops but the total sum in the 1st …

Hi @PaulN , See an example on how to calculate inside a repeat group: In the survey sheet: [image] In the choices sheet: [image]

Calculating inside a loop

Kal_Lam February 13, 2020, 2:51pm 12

Welcome to the community!

Reference xlsform:
Household (Count) Repeat Example.xlsx (37.0 KB)

Have a great day!

Conditional Repeat Count

Summation of different answers within a repeat group

Counting the Number of Individual in a household

Matching the numbers being summed within a matrix table