Count items in visible rows only?

[prlaba]

I want to list some summary information at the bottom of a list. Som
columns contain categorical data, like gender and ethnicity.

I use AutoFilters to filter my list based on various column values.

The summary infomration at the bottom of the list needs to be based o
visible rows only. The SUBTOTAL() worksheet functoin works fine fo
simple functions like Sum, Count, etc., but won't allow me to count th
number of instances of a specific value in a column.

Basically, I need the functionality of the COUNTIF() function, bu
limited to visible rows only.

Any suggestions on how to do this?

Thanks

 

[Dave Hawley]

Hi

Why not filter it down futher with the criteria you would use in
COUNTIF?

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Frank Kabel]

Hi
have a look at
http://tinyurl.com/2rj59