sum filtered range

Originally Posted by sexgod

hi , i need to get the sum of a column that i can filter and only show the result of the visiable cells left but if not filtered then will show sum of all cells,

Hi,

try

=Subtotal(109,A1:A10)

hth
---
added, I think the Subtotal should still work in your 2007 version.
---

Bryan's solution works for xl 2003 onwards

http://www.contextures.com/xlFunctions01.html#Filter

if you got a older verison of excel try

http://www.xldynamic.com/source/xld....T.html#visible

VBA Noob