If the cells are hidden as a result of filtering, you could use something
like:

=SUBTOTAL(9,A2:A8)

If you have manually hidden the rows, I don't know how you achieve what you
want

Regards

Trevor


"Helpme" wrote in message
...
How do you total the number of cells in a column without includnig the
hidden
cells in the same column?