Dear Reader

Do you know whether there is a function that counts only the filtered
elements of a column and not the whole column?

Regards
Farhad

=SUBTOTAL(2,A2:A100)

Edit A2:A100 to include the entire list of data as if unfiltered. It then
returns a count of the filtered data.

Lookup subtotal in Help and you will find a number of different functions
that can be performed depending on the numerical parameter (2 in the above
example).

Regards,

OssieMac
"(E-Mail Removed)" wrote:

> Dear Reader
>
> Do you know whether there is a function that counts only the filtered
> elements of a column and not the whole column?
>
> Regards
> Farhad
>
>

try using the "Subtotal" function with the option number 2.

HTH


On Aug 23, 5:38 am, f_esfandi...@yahoo.com wrote:
> Dear Reader
>
> Do you know whether there is a function that counts only the filtered
> elements of a column and not the whole column?
>
> Regards
> Farhad

On Aug 23, 5:38 am, f_esfandi...@yahoo.com wrote:
> Dear Reader
>
> Do you know whether there is a function that counts only the filtered
> elements of a column and not the whole column?
>
> Regards
> Farhad

Select the items in the column and then use the functions in the
bottom right corner of the window to COUNT the visible cells