Filter question

K

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?
 
L

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)
 
Top