Count filtered data only

[paulharvey]

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

[Norman Jones]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>