Count filtered data only
 

Is it possible for one of the count or sum commands to only coun
filtered data using the autofilter command

--
paulharve
-----------------------------------------------------------------------
paulharvey's Profile: http://www.excelforum.com/member.php...fo&userid=2522
View this thread: http://www.excelforum.com/showthread.php?threadid=38804

Count filtered data only
 

Hi Paul,

See the Excel SubTotal worksheet function in Excel help,

To sum a filtered A2:A20 range, try:

=SUBTOTAL(9,A2:A20)

---
Regards,
Norman



"paulharvey" wrote
in message ...

Is it possible for one of the count or sum commands to only count
filtered data using the autofilter command?


--
paulharvey
------------------------------------------------------------------------
paulharvey's Profile:
http://www.excelforum.com/member.php...o&userid=25227
View this thread: http://www.excelforum.com/showthread...hreadid=388047