I have the formula below to calculate the unique values in the specified cells.
When I apply a filter to a column on the spreadsheet, I'd like it to change the value.
E.g. The formula returns 100 when unfiltered. If I filter to show any data where...