I don't want to count hidden cells

C

CENorth7272

Is there a way to count only the visible cells in a given range.

I don't know how to use VB so if that is the only way to accomplis
this task, could somebody please type up the code so I can use it in m
spreadsheet (if this would be too much work I understand)

Any help is appreciate
 
A

Andy B

Hi

Have a look at the SUBTOTAL function in help (under SUBTOTAL worksheet
function). It might do the job for you, although I believe it only works
with AutoFiltered hidden rows.
 
P

Peo Sjoblom

Do a google search on "count visible cells only" and there should be many
macros
If you have excel 2003 there is a function called subtotal, previous
versions can us the subtotal to count visible
cells that are filtered but 2003 can do it with hidden rows as well
 
D

David McRitchie

Interesting question. You would need a macro.

The hidden cells how are they hidden: i.e.
Filters, Hide Columns / Rows, Subtotals.
Plus I guess one might consider (not consider):
scroll area, print area
 
Top