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


--
spartikus411
------------------------------------------------------------------------
spartikus411's Profile: http://www.excelforum.com/member.php...o&userid=34933
View this thread: http://www.excelforum.com/showthread...hreadid=547034

Adding only the filtered results
 

Hi Sparticus,

Try:

=SUBTOTAL(9,B1:B100)


Change B1:B100 to the range of interest.


---
Regards,
Norman



"spartikus411"
wrote in message
news:spartikus411.28o0jm_1149067501.6763@excelforu m-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