Filter question
 

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?

Filter question
 

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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"katie3309" wrote:

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?