autosum with filter excel 2007

[Guest]

I have a small database I'm using and when I filter nad try to use the
autosum I'm getting a wrong answer. I think excel is also including numbers
not in the filter range I've chosen.

Any suggestions or am I doing something wrong.

Thanks

 

[Ron de Bruin]

hi Chris

Look in the Excel help for the Subtotal worksheet function