count and filter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

f_esfandiari@yahoo.com - 23 Aug 2007 10:38 GMT

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

Reply to this Message

OssieMac - 23 Aug 2007 11:46 GMT

=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

> Dear Reader
>
[quoted text clipped - 3 lines]
> Regards
> Farhad

Reply to this Message

Dolphinix - 23 Aug 2007 14:29 GMT

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

HTH

On Aug 23, 5:38 am, f_esfandi...@yahoo.com wrote:

> Dear Reader
>
[quoted text clipped - 3 lines]
> Regards
> Farhad

Reply to this Message

Matt - 23 Aug 2007 14:52 GMT

On Aug 23, 5:38 am, f_esfandi...@yahoo.com wrote:

> Dear Reader
>
[quoted text clipped - 3 lines]
> 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

Reply to this Message

Rate this thread: