Count filtered data only

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

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" <paulharvey.1sdkij_1121706384.1146@excelforum-nospam.com> wrote
in message news:paulharvey.1sdkij_1121706384.1146@excelforum-nospam.com...
>
> 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
>