Summary tables may refer to as or include:
The total count of rows/logs in the previous default table (e.g. snag lists, employee attendance sheet, log sheets, etc.)
The total count of instances a number/text is used in either a prefilled or default table (e.g. Pass/Fail forms, Approve/Not approved forms)
The sum/average/total of numbers from a previous table
Use a prefilled table as your summary table. Navigate your cursor to the left tab and choose 'Prefilled table' under 'Table'. You can set your number of columns and rows as required, and which cells are your designated display cells. There are two ways you can input the data in your summary table:
Manual input
This is pretty much straightforward. You set your label cells as 'Prefilled text' fields and your display cells as 'Text' fields.
Using formulas
You use formulas to duplicate, count, total or display the information making it easier to populate data.
Using Formulas:
These are some common formulas you use for populating data in your summary table. Make sure to set the display cells as 'Formula' fields.
To copy off data from one cell to the summary display cell,
=Source_Table!Source_Cell
To convert a number into text in a given format to the display cell,
=TEXT(Source_Table!Source_Cell, Format)
To count the number of instances in a column,
=COUNTIF(Source_Table!Column:Column, Criteria)
To calculate for the sum of a column,
=SUM(Soruce_Table!Column:Column)
To calculate for the average,
=AVERAGE(Source_Table:Column, Column)
Using IF() formula to set conditions to display on your display cell,
=IF(Condition, Value, Otherwise_Value)
Using IFS() formula to set conditions to display on your display cell,
=IF(Condition_1, Value_1, Condition_2, Value_2, Condition_3, Value_3, Condition_n, Value_n)