Totaling the instances of Yes and No items means creating a summary table that displays how many times “Yes” and “No” are selected within a form. This formula works for both Default and Prefilled tables and allows you to dynamically track responses as users complete the form.
Prerequisites
Before you begin make sure you have the following:
Plan: All Plan Types
Permission: Home Folder (Template Library) – Org Controller (or higher); Team Folder – Project Controller (or higher)
Skills Required: Dashpivot, Basic Excel or Google Sheets Formula
Device Type: computer
Subscription: Dashpivot
Step-by-Step Instructions
In the Template Editor, add a Default or Prefilled table as your source table.
Set the relevant cells to a List field and manually enter the options “Yes” and “No” (and “N/A” if required).
Add another Prefilled table to act as your summary table.
In the summary table, change the display cells to Formula fields.
Enter the following formula:
=COUNTIF(Source_Table!Column:Column, "Text")
Replace:
Source_Table with your data table name.
Column with the column containing the Yes/No values.
"Text" with either
"Yes"or"No".
Example
If your Default table is named Table1 and the Yes/No values are in Column A:
For Yes:
=COUNTIF(Table1!A:A, "Yes")
For No:
=COUNTIF(Table1!A:A, "No")