Filter question

[katie3309]

when i filter data, the number of responses no longer appears in the bottom
left corner of the screen. how do i know how many items meet my filter
criteria?

 

[Luke M]

The status bar counter is known to be unreliable. You can use the following
formula, which gives a count of data that is unfiltered (doesn't count blank
cells though, so set the range to a column that always has data)

=SUBTOTAL(2,A2:A100)