COUNTING COLUMNS AFTER DATA FILTER

[_Bigred]

(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]

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]

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.