Great Question! Use Subtotal!!
Function Solution:
http://www.contextures.com/xlFunctions01.html#Filter

VBA Solution:
http://www.mrexcel.com/archive/VBA/5209.html
http://www.ozgrid.com/News/excel-subtotal-dynamic.htm

HTH,
Ryan---

"Jason V" wrote:

I am trying to filter on a column and then I want to sum the result of the
visible rows. How do I fo this in code?

Thanks
--
Jason V