P
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
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