This is a picture blog. Self-explanatory! Learn how to Sum visible cells only using the Aggregate function.
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.