Counting how many times “Yes” or “No” is selected in a prefilled table helps you quickly summarise responses within your template. Instead of manually counting entries, you can use the COUNTIF() formula to automatically total specific selections such as “Yes” or “No.” This is useful for checklists, inspections, pass/fail indicators, and other structured forms built in Dashpivot Web.
Prerequisites
Before you begin make sure you have the following:
Plan: FreeTrial, Standard, Pro, Premium, Platinum
Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot Web
Step-by-Step Instructions
Open the template that contains your Prefilled table.
Ensure the rows you want to count contain a Yes/No selection field.
Click into the cell where you want the total count to appear at the bottom of the prefilled table.
Set the cell type to Formula.
Enter the
COUNTIF()formula at the bottom of the table using the column range and the value you want to count.For example, enter this formula in cell A6
=COUNTIF(A1:A5, "Yes")
Press Enter to apply the formula.
Save the template.
Note
The
COUNTIF()formula is not case sensitive, so "yes", "Yes", and "YES" are counted the same.To count "No" selections instead, replace
"Yes"with"No"in the formula.