# Totalling Data With Autofilter On

Apr 8, 2009I have 3 columns of data and am using an autofilter to sort it. At the bottom I have a formula =subtotal(9,cells requested) which magically shows me the sum of the data showing only (excludes all the figures which are hidden - it's fabulous). However I was wondering if it is possible to have the same formula but to count the number of things shown instead of sum and another to average.