Hello I have a Zoho Form that contains both Individual Client IDs and Household IDs that are imports from an external database.

Fields:  Client_ID & Household_ID

I am trying to figure out the best way to determine a Zoho script that would calculate the total number of Households or Families using the Household_ID field either if they are Single (only 1 Household_ID) or Multiple Members (more than 1 member having the same Household_ID) and tallying the results.

I would greatly appreciate any assistance on this.

Thanks.