Filtered Summary Aggregation Calculation Types

Select one of 4 calculation types to filtered data to enable dynamic summarization of data before it is inserted into the destination range. The Calculation Type is activated when the Enable Summary Calculations property is checked. The data aggregation is driven by theAggregate Column Index property. Each column is is controlled independently as the data is aggregated as a List, Count, Sum, or Average.

filtered summary

List– List will filter the column and place the list of unique values into the destination as a comma separated string.
Count– Count will provide a numerical count of the number of records.
Sum– Calculate the sum of all values for each record within the column
Average– Calculate average of all values for each record within the column.