I have a checkbox table with 10 rows, and four columns (excluding headers, row/column names etc)
I have filtered the table to hide the rows that have a check in all of the columns (these rows are fully “complete”)
The table now shows five rows, with a mix of checkboxes completed, just by looking at the table, there are 3 checks in “Column A”.
I want to count the number of checks in “Column A”, without including values from the rows that are “hidden” as a result of the filter. i.e the “Summary Count” at the bottom of the table shows 8 in this column (5 from the rows that have been checked and hidden, plus 2 from those that are still visible.