COUNTING COLUMNS AFTER DATA FILTER

_Bigred · Dec 16, 2003

(Excel 2000)

Somone answered this a while back, but I lost it due to cpu crash.

If I have a sheet that uses the "Data>Auto Filter" feature, how do I count,
sum etc... on the various columns?

I know it is something pretty simple, but can't seem to remember it.

TIA,
_Bigred

Dave Peterson · Dec 16, 2003

take a look at =subtotal() in excel's help.

And remember that you can search google for any post--including the ones you
wrote (and the replies, too):

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm

Debra Dalgleish · Dec 16, 2003

You can use the Subtotal function. The first argument specifies which
function should be used, e.g. in =SUBTOTAL(9,A1:A100), the range will be
summed.

COUNTING COLUMNS AFTER DATA FILTER

_Bigred

Dave Peterson

Debra Dalgleish