Counting the Range showing when the filters are on
Posted by Paul Magruder on February 26, 2001 4:34 AM
Is there a way to count only the values showing, after the filters are on. I am using a macro to turn the filters on, and the range of the data changes with each data entry. The problem is if I use the count function ( and the range is set for the entire column),Excel counts all the data in the column,instead of only the filtered data. I also need to "Sum" in the same way.
Thanks in advance