Google Sheets – How to Count Filtered Data When Using Slicer

formulasgoogle sheetsgoogle-sheets-filter

Data After slicer

The sheet above shows data filtered by using Slicer.

How can I count rows when I filter data by a column using the slicer?

Let's say I want the counted result to appear in cell L4. If I use the counta() function, it still counts all rows instead of the filtered rows.

Best Answer

Please use the SUBTOTAL function

=SUBTOTAL(3,A6:A)

enter image description here

Functions used:

Related Topic