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.