ExcelBanter - Count cells in a column that has a autofilter

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count cells in a column that has a autofilter (https://www.excelbanter.com/excel-worksheet-functions/116921-count-cells-column-has-autofilter.html)

Irv

Count cells in a column that has a autofilter

I need to find a formula that counts the number of cells in a column that has
data (text, &/or number), but the kicker is I need that number to change when
I use a autofilters.

Ron de Bruin

Count cells in a column that has a autofilter

Hi Irv

Look in Help for the SubTotal worksheet function

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Irv" wrote in message ...
I need to find a formula that counts the number of cells in a column that has
data (text, &/or number), but the kicker is I need that number to change when
I use a autofilters.

All times are GMT +1. The time now is 05:03 AM.