count and filter

  • Thread starter Thread starter f_esfandiari
  • Start date Start date
F

f_esfandiari

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
 
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
Click to expand...

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