Simple Count formula required
Hi,
I need help on a simple formula, that's just irritating me. Basically I
would like to use the Count function on a list of data when the Autofilter is
on. For example, when I use the Subtotal function on the filtered results, it
only returns the total of the filtered items, yet when I use the Count
function it returns the total number of all the results, not just the
filtered ones.
Thanks for the help!
|