Skip to main content
All CollectionsSupport GuideDashpivot - WebFormulas Functions
How to total all instances of Yes/No items in a form
How to total all instances of Yes/No items in a form

Learn how to total the number of times Yes and No are selected in a form.

Janmari Tanga-An avatar
Written by Janmari Tanga-An
Updated over 6 months ago

Totaling the instances of Yes and No items means that you have a summary table that displays the number of times Yes and No are selected. The formula to be used is applicable for both Default and Prefilled tables.

To start, navigate your cursor to the left tab and choose either Default or Prefilled table as your source table. It is advisable to use a dropdown list for the Yes/No selections. Change the cells into a 'List' and manually input 'Yes' and 'No', or if required, additionally 'N/A'.

Drag another table (Prefilled table) as your summary for the total counts. Set the display cells into 'Formula fields' and input the formula shown:

=COUNTIF(Source_Table!Column:Column, "Text")

where:

Source_Table - the data table

Column - the column where the Yes/No values are located

Text - for this case either 'Yes' or 'No'

For example:

Given a Default table (Table 1) where the user inputs the name of employee and if they have renewed their licenses. (This could be a manual input or a difference in dates.) And the summary table (Table 2) which displays the total counts of 'Yes' and 'No'. Change the cells in your summary table as 'Formula' fields, and input the following formulas:

For Yes:

=COUNTIF(Table1!A:A, "Yes")

For No:

=COUNTIF(Table1!A:A, "No")

Did this answer your question?