How to sum a filtered list by visible cells only?

I have a table that I want to filter by a criteria. I filter the criteria by selecting by color. How do I get a simple formula like sum to calculate only the visible cells that I choose by this filter? Thanks in advance.

I think you can use =SUBTOTAL(109, sum range)


Regards

In Excel 2010 you could also use AGGREGATE function like this

=AGGREGATE(9,6,A1:A10)

This has some additional features that SUBTOTAL doesn't have, e.g. the 6 in the above tells it to ignore any error values