Totaling all instances of all dropdown items in a list means that you're tallying the counts for each item in the dropdown list, such as counting for Item 1, Item 2, Item 3,... Item n.
To start, navigate to the left tab and choose either a 'Prefilled' or 'Default' under 'Table. The formula is possible for the two. You can set your table and choose whichever column is intended for the drop down selection.
Drag another table (Prefilled) as your summary table and designate your cells as the items in the column. These will be your display cells and set them into Formula fields.
Use the formula in the display cells,
=COUNTIF(Source_Table!Source_Cell_n, Item_n)
For example:
Given that your form is a log of equipment used in a month. The engineering department at the owner's side needs this form to keep track of the employees who are using all of their company-issued construction equipment in a month, separate from the individual log forms. In one of their tables, they need a summary of the quantities each equipment was used in a month.
These are the items in the drop down list:
Item 1 - Excavator
Item 2 - Crane
Item 3 - Backhoe
Item 4 - Boom lift
Table 1 (Default Table)
(Date field) | Equipment used (Dropdown list of construction equipment) | Used by (Text field) | Comments (Text Field) |
Table 2 Display Table (Prefilled table)
Counts the Excavator was used | Counts the Crane was used | Counts the Backhoe was used | Counts the Boom lift was used |
(Formula field) | (Formula field) | (Formula field) | (Formula field) |
Counts the Excavator was used formula:
=COUNTIF(Table1!B:B, "Excavator")
Counts the Crane was used formula:
=COUNTIF(Table1!B:B, "Crane")
Counts the Backhoe was used formula:
=COUNTIF(Table1!B:B, "Backhoe")
Counts the Boom lift was used formula:
=COUNTIF(Table1!B:B, "Boom lift")