close
in an autofiltered filed, where some rows are hidden, how do i count the
number of rows that remain in a column? I don't want to have to copy to
another worksheet, just looking for some function or trick to use on the
filtered worksheet itself
=SUBTOTAL(103,column of cells) -- like =SUBTOTAL(103,A1:A50) even if many
rows are hidden.
this is a counta of VISIBLE cells.
quot;jimmj1210quot; gt; wrote in message
...
gt; in an autofiltered filed, where some rows are hidden, how do i count the
gt; number of rows that remain in a column? I don't want to have to copy to
gt; another worksheet, just looking for some function or trick to use on the
gt; filtered worksheet itself
全站熱搜
留言列表
