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