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")