Thread: Filter question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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?