ExcelBanter - count filtered data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - count filtered data (https://www.excelbanter.com/excel-discussion-misc-queries/136030-count-filtered-data.html)

ccravens

count filtered data

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...

pinmaster

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...

All times are GMT +1. The time now is 01:42 AM.