How to Sum visible cells only in Excel

This is a picture blog. Self-explanatory! Learn how to Sum visible cells only using the Aggregate function.

Aggragate function to Sum visible cells only

Works only in vertical direction (not horizontal). It is best to use it with Excel Tables as shown above. That way, adding more data will automatically update the formula results.
Works from Office 2010 onwards.

Comments? Suggestions? Wish list?