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.