View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default count filtered data

Hi,

Have a look at the Subtotal function.

Regards!
Jean-Guy

"ccravens" wrote:

I've got a db that is filtered on many criteria. I need a quick way to count
records that are visible after filtering. Right now, all the COUNT/FILTER
formulas I try include data from hidden rows/columns. I think this is easy, I
just can't get it to work...