Adding only the filtered results

i have tons of info with about 10 columns, when i use the autofilter, i want to add the values in a column but only the filtered ones. how can i do this?
thank you in advance

Hi Sparticus,

Try:

=SUBTOTAL(9,B1:B100)


Change B1:B100 to the range of interest.


---
Regards,
Norman



"spartikus411" <spartikus411.28o0jm_1149067501.6763@excelforum-nospam.com>
wrote in message
news:spartikus411.28o0jm_1149067501.6763@excelforum-nospam.com...
>
> i have tons of info with about 10 columns, when i use the autofilter, i
> want to add the values in a column but only the filtered ones. how can
> i do this?
> thank you in advance
>
>
> --
> spartikus411
> ------------------------------------------------------------------------
> spartikus411's Profile:
> http://www.excelforum.com/member.php...o&userid=34933
> View this thread: http://www.excelforum.com/showthread...hreadid=547034
>